M
magspc
Have list of invoices organized by date and trying to summarize total revenue
by a month on a summary sheet.
by a month on a summary sheet.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
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
[email protected]
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
[email protected]
M
magspc
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
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
D
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
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