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
on a summary worksheet. Example: January expense summary data, February
expense data. Having their totals display on worksheet 1 summary.

"Nick Hodge" wrote:

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
HIS


"magspc" wrote in message
...
Have list of invoices organized by date and trying to summarize total
revenue
by a month on a summary sheet.