Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2587
  • 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 HensonFinance AnalystCommented:
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Rob HensonFinance AnalystCommented:
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 HensonFinance AnalystCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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