LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data searching between sheets YJL Excel Discussion (Misc queries) 2 November 10th 05 03:01 AM
Data searching between sheets YJL New Users to Excel 1 November 10th 05 01:17 AM
Searching for first and last in a table to chart (gantt) VLB Excel Discussion (Misc queries) 3 October 31st 05 11:57 AM
Searching for partial data in a column Severin Excel Discussion (Misc queries) 2 October 3rd 05 06:33 PM
Formula for Searching & matching two values in excel Chris Excel Discussion (Misc queries) 1 January 7th 05 04:34 PM


All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"