I am looking to create a dynamic hyperlink to navigate to cell based on value rather than a specific cell address. Here is my scenario:
Workbook “Client Renewal Forecast” sheet “2015 Forecast” cell A67 = client name
Sheet “'Rollforward by Product” is pivot table where somewhere in range A:A...
I am trying to do a variance analysis between pivot tables in a local file and pivot tables in a file posted to sharepoint. I would like to link to sharepoint file and create a linked copy of the pivot tables to the network file so I only ever have to open the one file for refreshing and...