Hi all you Excel wizards,
I have a spreadsheet that contains, say 26 tabs, each being named a different letter of the alphabet.
In the 27th tab I have a scroll down box, or a data validation list, that contains the names of all the other 26 tabs (A-Z).
Is there a way of selecting, for example, the letter 'T' from my drop down box and from this selection Excel will automtaically go to that tab? I have tried so many ways but to no avail. surely this can be done??
If anyone can be kind enough to send in the vb code, so that all I have to do is copy and paste it onto my spreadsheet that be would great!
Thank you in advance if you can indeed solve this one for me.
2007-03-12
05:23:48
·
5 answers
·
asked by
No1DiamondGeezer
1