• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Return a dynamic reference to a cell beside a pivot table


New Member
Hello again Everyone,

I am trying to find a way to return values in cells beside a pivot table. The data set that the original pivot table draws from does not contain certain data so it is accumulated in a second worksheet. What I want to know is if I can return specific values to match up with the pivot table data. If the original pivot table changes, I would like the data returned to still match up.

I have attached an example for reference. (note the pivot table data is only a small excerpt) I hope this example is clear enough to understand.

Thank you in advance.