What I am trying to do is based off a selection someone makes, pull in data from a pivot table that is names that would be behind the scenes that they would not see. For example, if they select Checking, I would want all data in the Checking Pivot table to render on the spreadsheet where they made the selection. However, if they change the selection to Savings, I would want the info from the Savings Pivot table to render. I am assuming it is a IF function, but not sure how to make sure all Pivot table info pulls in. I know how to do the If function with a Vlookup but some of these pivot tables do not have the same number of columns so I don't think that will be as clean.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pulling data from a named Pivot table into a new spreadsheet
- Thread starter hawkfan1
- Start date
Similar threads
- Question
