ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table: hyperlink back to source data (https://www.excelbanter.com/excel-discussion-misc-queries/116370-pivot-table-hyperlink-back-source-data.html)

Tomas

Pivot table: hyperlink back to source data
 
I am using pivot table to generate sales forecast from my source data. Is
there a way I can directly jump back to the source data to edit them? If I
double click the value in pivot table I only get a detail on a separate new
sheet with respective records. Can I include any form of hyperlink or macro
action into the pivot table to manage the link? Thanks.


All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com