Need help (pivot table)

[dolphn22]

If I have a report on one tab, and a pivot table on another tab, is there a way to link one of the cells on the report tab to a cell on the pivot table, so if you double clicked the cell on the report tab, it would pull up the data behind the #, similar to if you double clicked in the pivot table.
Bottom line is I want to have it to where if you double click on a figure a report, it would create a second tab that shows all of the lines that make up the #.
Is there a solution to this?

 

[Tom Urtis]

Duplicate
http://www.mrexcel.com/forum/showthread.php?t=539011

Always best to stick to the same thread.

 

[dolphn22]

Hi Tom,

Do you just flag duplicates, or do you try and help people out with constructive responses?

Also, I only posted twice because I thought maybe my first post was confusing, and I tried to clarify exactly what was needed.

If you could provide a constructive reply, that would be great.

Thanks,
dolphn22

 

[Jon von der Heyden]

Hi dolph22

Tom is a valued member at this community and if you were to take the time to review his posting history you will notice that he has helped countless people. Please do not challenge his participation here.

Also, the duplicates rule (rule 9) exists to serve you and the forum regulars. The forum regulars because many don't like the idea of addressing questions that have already been answered, and you because regulars might avoid you if they discover you repeat your question threads.

Please posts all follow-ups, be they clarifications, further questions, or bumps to the original thread. Per the forum rules duplicate threads will be locked or deleted.