Hi guys,

is there any vba codes that can show tab/sheet that is based on the filter selection.

for example:

Cell A1 have a data validation of Apple, orange and Mango

i have 3 tabs named Apple, orange and Mango.

so everytime i select Apple on the MAin page filter. Apple tab will show. and if orange then orange tab will show.

thanks.