Excel trying to sort list by a range of dates

[Guest]

Have list of invoices organized by date and trying to summarize total revenue
by a month on a summary sheet.

 

[Nick Hodge]

It's a bit of a brief description, but if your data is arranged well. (One
invoice per line with date in recognisable format) you could use a pivot
table and 'group' the data by month

Check out Pivot Table in help and if you need more guidance, post back

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Guest]

OK - Did the training on Pivot tables, Question: Can you take data from two
different lists. to make pivot table?? I have a list for XX expense and
list with Y expense. Combine the two to display information. The other
issue is trying to take summary data from a pivot data and have it displayed

 

[Debra Dalgleish]

If you create a Pivot Table from multiple consolidation ranges, you
won't get the same pivot table layout that you'd get from a single
range. There's an example here:

http://www.contextures.com/xlPivot08.html

If possible, store your data in a single worksheet, with a column to
identify the individual user, and you'll have more flexibility in
creating the pivot table.

To extract data from the pivot table, you can use the GETPIVOTDATA
function. There are examples and instructions in Excel's Help, and here:

http://www.contextures.com/xlPivot06.html