| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table data
I'm not sure if this is the correct forum for this but here goes.
I have a pivot table that draws from several pages. when I click on the values to find out what makes the values I get a second sheet that has: ROW Column Value Page1 Item number Cumber title a date Item3 (or Item1, or Item2...you get the idea) How do I change the "Item#" to the actual sheet it came from. if I need to explain more please let me know. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Distributing Pivot Tables where pivot table data can't be accessed | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Threaded Mode
