happy_smiler1
New member
- Joined
- Aug 28, 2012
- Messages
- 67
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- office 365
hi all,
I have a summay table which gets its information from a pivot table on the same worksheet. Instead of using ctrl + selecting certain cells within a pivot table to get the answer for my summary, is there a formula that i could use that could do the job because the pivot table is constantly being updated each week, would make it alot easier to have a formula than manually clicking each cell that i need.
This is probably impossible as the pivot table is dynamc, but any help or suggestions would be greatly appreciated.
thank you.
I have a summay table which gets its information from a pivot table on the same worksheet. Instead of using ctrl + selecting certain cells within a pivot table to get the answer for my summary, is there a formula that i could use that could do the job because the pivot table is constantly being updated each week, would make it alot easier to have a formula than manually clicking each cell that i need.
This is probably impossible as the pivot table is dynamc, but any help or suggestions would be greatly appreciated.
thank you.