View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin R
 
Posts: n/a
Default searching for tab


Hi all, I have written a workbook with some 40 worksheets in it to be
used as a reference database. Each of the 40 worksheets has a specific
name (tab). Is there a program/formula that I can put on the very first
page so that a user can input the name of the sheet/tab they want and
that sheet will open for them. Basically to stop them having to sift
through 40 tabs to find which sheet they need.
Thanks
Kev


--
Kevin R
------------------------------------------------------------------------
Kevin R's Profile: http://www.excelforum.com/member.php...o&userid=30529
View this thread: http://www.excelforum.com/showthread...hreadid=501808