• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Hyperlink Pivot table data
#1

.xlsx   HyperLink.xlsx (Size: 326.75 KB / Downloads: 3)

Problem Area:
if we click on this link then it is correctly select the linked pivot cell.
However this is not dynamically and if we have some data in MAY in future then it will still select the "B8"data in pivot table which will be incorrect.
Help Required:
when click on data of dashboard, i will go to my correct month pivot data and then anyone can extract those data by double click.
Both Dashboard and Data Pivots are in different sheet in same workbook.
  Reply


Related Topics
Topic Author Replies Views Last Post
  Pivot Table Making Pivot table Jyoti 1 1,162 17-Feb-2020, 12:39 PM
Last Post: Vivekananda Sinha
  Pivot Table Pivot Table Query Lovedeep sharma 2 1,654 24-Sep-2019, 06:01 PM
Last Post: Anil Kumar Pal
  Pivot Table How to make dynamic two RAW switch in single Pivot Amitg9595 0 977 01-Jun-2019, 05:11 PM
Last Post: Amitg9595
Date Hyperlink Index of sheets with Hyperlink Harshi Gupta 2 2,144 27-Jun-2018, 05:59 PM
Last Post: Vivekananda Sinha
  Pivot Table Can we apply group in Pivot table Rinku Sharma 1 1,554 27-Jun-2018, 05:55 PM
Last Post: Vivekananda Sinha
  Pivot Table Range issue in pivot table Amit5210 3 2,486 30-May-2018, 03:38 PM
Last Post: Abhishek Jain
Music Hyperlink Hyperlink Access Aman Kumar 1 1,767 24-May-2018, 12:33 PM
Last Post: Vivekananda Sinha
  Pivot Table Pivot Querry Shankardeep 1 1,517 22-May-2018, 05:02 PM
Last Post: Vivekananda Sinha
  Pivot Table How to make pivot on below condition Anil Kumar Pal 1 1,525 16-May-2018, 01:00 PM
Last Post: Vivekananda Sinha
  Others How to merged table in excel Dharmesh Kumar Srivastava 1 1,922 12-Nov-2017, 06:17 PM
Last Post: Vivekananda Sinha
Star Pivot Table Pivot Tables Sanjeev Singh 1 1,856 05-Nov-2017, 11:55 AM
Last Post: Mohit Sharma
  Pivot Table pivot table Vinod Dobhal 2 2,364 05-Sep-2017, 03:11 AM
Last Post: Vinod Dobhal
  Shortcut Access the Hyperlink Aman Kumar 1 2,000 18-May-2017, 09:06 AM
Last Post: Vivekananda Sinha

Forum Jump:


Users browsing this topic: 1 Guest(s)