Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect eq'n to link info from vba-generated worksheet to summary
Hi,
I've used vba to create new worksheets. On these worksheets, pivot tables are automatically generated which get their page filters from Column C on my Summary Sheet. So far so good! My problem is using the Indirect function to link pivot table fields back to my summary sheet. Since I don't know the name of sheet (which are equal to the values entered in Column C on my Summary sheet) or the position of the pivot table totals in advance, I need an "Indirect" equation to locate pivot table totals and to insert them into adjacent totalling fields to the right of the my user-entered page filters. Here is my indirect equation so far: =INDIRECT("'"&C14&GETPIVOTDATA("ACTUALS",ITB202123 P!$D$11,"ActivityII","$")) Does anyone have any insights using Pivot table references in conjunction with Indirect functions? Thanks in advance! -- Kent Lysell Financial Consultant Ottawa, Ontario W: 613.948-9557 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTables - Calculations based on generated summary data | Excel Discussion (Misc queries) | |||
Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
Can I link every "fourth" row to a summary worksheet? | Excel Discussion (Misc queries) | |||
picture as link in Excel generated html | Excel Programming | |||
link drop down menu to info in worksheet | New Users to Excel |