Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table with Multiple sheets
Hi,
I need to create a pivot table from two sheets the range columns are the same but the pivot table need to be categorize by the content of one the column versus another one. Find the excel spreadsheet, on the sheet 3 it's an example of how the pivot table have to be. I'm a novice on excel and I am not really sure I can do that without macro. -------------------------- http://www.savefile.com/files/1861224 Thanks Dy' |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table with Multiple sheets
This uses Excel 2007 and Reverse Pivot Table.
Includes update macro. http://www.savefile.com/files/1861776 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table with Multiple sheets
Great work Thank You so much!! I try to understand how do you do it. But it
still confusing for me! AnyWay!! You're the Best Cheers "Herbert Seidenberg" wrote: This uses Excel 2007 and Reverse Pivot Table. Includes update macro. http://www.savefile.com/files/1861776 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table with Multiple sheets
Added Notes to explain macro.
Same link. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table to reference multiple sheets | Charts and Charting in Excel | |||
Pivot table from multiple sheets - odd result | Excel Discussion (Misc queries) | |||
Pivot table for multiple sheets | Excel Discussion (Misc queries) | |||
Pivot Table from multiple sheets | Excel Discussion (Misc queries) | |||
Pivot Table--How can I create from multiple sheets? | New Users to Excel |