Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel 2010 - Pivot Table & linking back to source data

Posted on 2014-01-31
8
Medium Priority
?
2,340 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 34

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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
LVL 34

Accepted Solution

by:
Rob Henson earned 2000 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
 

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 34

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

916 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