Hi Mynda,
Sorry, I'm back with a new query.
I have remove the chart and replaced with PivotTable1 on the Report tab
I want to get to a point where I can select a site in this table and see the relevant site data on the 'Sites' tab
I have added a Hyperlink that takes it to the sites tab but don't know how to link it it to the relevant data in PivotTable6 on the Pivot Table tab. I think I need to remove the Sites slicer and replace with something else but have come to the end of my knowledge/skills
Any help would be greatly appreciated
Thanks
Paul
Hi Paul,
Please start a new topic for a new query as this is more likely to get an answer than burying it on the bottom of an old post. I've moved this one for you.
You would need to use VBA to detect the hyperlink clicked on the Report sheet and then filter the data on the Sites sheet accordingly. Alternatively, you could use a data validation list to allow the user to select the site number and then click the data validation list item selected to go to the Sites sheet which displays the relevant data, as explained in this post on data validation list hyperlinks.
If you prefer to use VBA, then post your question in the VBA forum.
Mynda
Thanks Mynda
I will post a new topic in VBA section
Regards
Paul