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.
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
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.
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
Thanks for your help
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.myonlinetraininghub.com/excel-tabular-data-format
See attached file for an example.
