Hi,

I am stuck to a problem, seeking help from the experts.

Having first sheet named as Data, where I have two drop down list

Grade: m3, m4a,m4b,m5 ....
Location: Factory, Region...

Again, having 10 more sheets as such:

m3
m4a_factory
m4a_region
m5_region
m5_factory
m6a_region
m6a_factory
... and so

Now I want to unhide and make active only that sheet, which I select from the data sheet drop down.
Example: If I select M4A from Grade dropdown and Region from Location dropdown, then M4A_Region should get unhide and active and rest will be hidden.

Thanks in advance,

Sample Sheet is enclosed.
SampleWorkbook.xlsx

Regards,
Shiven