Hi,
The title doesn't make much sense but what i am asking.
I.E - If you click a field in a pivot table, it will open a new sheet within the workbook with a breakdown of information that you clicked on.
If i have a VLOOKUP in sheet1 reading from a pivot table in sheet2, is there a way that if someone clicks on the VLOOKUP cell, it can open the a new sheet within the workbook, as if you clicked on it from the pivot table?
Thanks :\
Bookmarks