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.
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
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
Asked:
-
5
3
1 Solution
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).
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.
If pivot tables would bring across the sourcedata hyperlinks, that would be exactly what I'm looking for.
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
Thanks
Rob H
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?
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?
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 Already a member? Login.
Featured Post
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.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Does that help?
Thanks
Rob H