Solved

Excel 2010 - Pivot Table & linking back to source data

Posted on 2014-01-31
8
1,890 Views
Last Modified: 2014-03-04
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
Comment
Question by:kazmdav
  • 5
  • 3
8 Comments
 
LVL 31

Expert Comment

by:Rob Henson
ID: 39823495
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
 

Author Comment

by:kazmdav
ID: 39823897
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
 

Author Comment

by:kazmdav
ID: 39828597
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
 
LVL 31

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 39829304
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:kazmdav
ID: 39833912
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
 
LVL 31

Expert Comment

by:Rob Henson
ID: 39833946
Bit pushed for time at the minute but I will see what I can do.
0
 

Author Comment

by:kazmdav
ID: 39845059
Hi Rob, if you don't have time, there is no pressure to do so.

Regards,
Karen
0
 

Author Comment

by:kazmdav
ID: 39905137
As no further response, I'll close this question. If I learn anything more I'll add it.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

This article will show you how to use shortcut menus in the Access run-time environment.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now