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.