I have a vba code to show and hide sheets based on the name. I now need a code that will show several sheets based on a word selected in drop down menu. Example if I select south, I want it to show all the store numbers under the south division. I have put all the store numbers under south, central, and north divisions as well as the departments under department name in a data sheet and gave them names under name box. I just need it so when a division is selected it shows the stores belonging to that division. Thank You
Bookmarks