Log In
Register
Home
Active Member
February 20, 2020
Offline
Hi Team,
I a bit stuck. I am looking to create a work book with 10 spreadsheets within that book.
I have these sheets linked to the master sheet. I need to be able to hide all the sheets and when filtered a particular sheet on the master sheet all the date which is on that sheet to be displayed on the master.
hope I have managed to explain.
Trusted Members
December 20, 2019
Offline
Hi Charlton
I take it all the sheets will be in the one workbook? what range is being filtered the options worksheet or the master? Will you want to cllick on a hyperlink or a button? and what needs to be shown?
Purfleet
Active Member
February 20, 2020
Offline
Hi Purfleet,
What I really need is to, after completing all the input is to hide all the sheets and only display the master sheet. when you click on the tap to filter the site. the cell that is RED and pick up a site. I need the info on the sheet for that particular site I chose to display on the master. hope this make sense.
Trusted Members
December 20, 2019
Offline
Try the attached, i have created a couple of small macros to hide/unhide/go to pages, but using the indirect formula to look up the details on each sheet based on the red bar.
Purfleet
Active Member
February 20, 2020
Offline
Thanks for your help
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Just want to show you an alternative approach where there is no need to have extra sheets nor hiding them. You just need to organize your data in a structured way using tabular data format and then you can get the different values per site, year and whatever you would like to filter with.
https://www.myonlinetraininghu.....ata-format
See attached file for an example.
The following users say thank you to Anders Sehlstedt for this useful post:
Purfleet
1 Guest(s)
