• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2429
  • Last Modified:

Excel 2010 - Pivot Table & linking back to source data

Hi,
Is it at all possible to be able to click on a row within a pivot table and link back to the source row, please?

Sample workbook is attached. There are 3 row labels which I will refer to as 'columns'. For each item listed in each column, I would like to click on a cell and link back to the source cell.

For example;
-  I click on 'Another' (in column A in pivot table), it links me back to cell A191 in 'Sourcedata' w/sheet.

-  I click on 'Administrative Support Curriculum' (in column B in pivot table), it links me back to B190 in 'Sourcedata'

-  I click on 'Capital Budgeting Roadblock' (in column C in pivot table), it links me back to C184 in 'Sourcedata',

Cheers!
SampleCatalog.xlsx
0
kazmdav
Asked:
kazmdav
  • 5
  • 3
1 Solution
 
Rob HensonIT & Database AssistantCommented:
When Double Clicking on a Value in a Pivot Table it will generate a sheet with a filtered list of the source data that makes up that value.

Does that help?

Thanks
Rob H
0
 
kazmdavAuthor Commented:
Thanks Rob, I'll try it on Monday upon my return to work but I'm thinking 'no' because the reason that I want to return to the real 'Sourcedata' worksheet because it has other columns with hyperlinks in it that I want the users to have access to (the other columns are deleted in the 'Sample Catalog' workbook for confidentiality).
0
 
kazmdavAuthor Commented:
Hi Rob, it was a good try but not quite what I want.

If pivot tables would bring across the sourcedata hyperlinks, that would be exactly what I'm looking for.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Rob HensonIT & Database AssistantCommented:
How about setting the double click option to Off and then use the DoubleClick event to generate a variable value from the current row of the pivot table, take the user to the data sheet and filter on the value generated.

Thanks
Rob H
0
 
kazmdavAuthor Commented:
Rob,
That sounds like a good idea. While I understand the concept behind it, I only dabble in VBA coding & I struggle with it (my line of daily work is in workplace L&D  (not coding). Would you able to supply some code please?
0
 
Rob HensonIT & Database AssistantCommented:
Bit pushed for time at the minute but I will see what I can do.
0
 
kazmdavAuthor Commented:
Hi Rob, if you don't have time, there is no pressure to do so.

Regards,
Karen
0
 
kazmdavAuthor Commented:
As no further response, I'll close this question. If I learn anything more I'll add it.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now