Hello All,
Help please.
I have so many tabs with data in a workbook.
I want to be able to click on a list (combo box) to pull all the data relating to the tab whilst the tabs are hidden.
This means the workbook only displays a front and provides the information required when the droplist is activated.
How do I go about achieving that please?
Grateful for any help.
Many thanks in advance. PS, apologies if the topic has already been covered.
Best regards,
Stee Wan
Hi Stee
I don't see any reason why the list or combo box is unable to pull the data from the hidden tabs.
You did not specify whether the list/combo box are Form or ActiveX Controls.
I am only assuming it is a Form Control but it doesn't matter as both will able to pull the data.
Maybe you could attach a sample of your file for us to take a look.
Sunny
Thanks Sunny for the prompt response and desire to assist.
Said data is highly sensitive. I will look for some sample data online and use that to demonstrate what I mean.
