Display Source of Pivot Table in a Cell

[sean_nyc]

Hi there,

I am curious if anyone can help me with a formula that could find the source of the Pivot table and put it in a cell to show that it selected a specific range of source data. What I am doing is that I have a Pivot with VBA buttons that switches between two source data tabs, "Actual" and "forecast" via Buttons. I need a way of showing the source data on a summary tab, is this possible? I appreciate all ideas.

Thanks!!!