It is based upon your data validation being in cell H10. Change that to
suit.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"SAP PoD" wrote in
message ...

Hi,

Sorry, but I am a fairly basic Excel user and never copied code before.
I figured out where to put the code, but it does not seem to do
anything. Did I have to change some of the values in the code to
reflect my choices and the names of the worksheets I want them to go
to?

Sorry if that's a dumb question


--
SAP PoD
------------------------------------------------------------------------
SAP PoD's Profile:
http://www.excelforum.com/member.php...o&userid=37641
View this thread: http://www.excelforum.com/showthread...hreadid=572552