Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default How to find a worksheet by its name in a workbook?

Dear All:

I have a workbook where every day about 10 new sheets are added.
After I open the workbook how I can find a specific sheet by using the name
on the Tab of the sheet?

Please help!

Thanks!


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How to find a worksheet by its name in a workbook?

You could rightclick on the VCR/DVD like controls to the left of the horizontal
scroll bar.

You'll see a list of sheets popup where you can select the one you want (or
choose to see more, then choose).

Or use Ron de Bruin's xl2007 addin:
http://contextures.com/xlToolbar01b.html
(on Debra Dalgleish's site)

Alchemist wrote:

Dear All:

I have a workbook where every day about 10 new sheets are added.
After I open the workbook how I can find a specific sheet by using the name
on the Tab of the sheet?

Please help!

Thanks!



--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default How to find a worksheet by its name in a workbook?

I assume that you know the name of the sheet you want to find. Consider
always opening to a special index sheet. In column A of this sheet is a list
of all the other sheets. We can alphabetize this list whenever we want.
Each cell in the column will be a hyperlink to the corresponding sheet.

One click and there you are.
--
Gary''s Student - gsnu200826


"Alchemist" wrote:

Dear All:

I have a workbook where every day about 10 new sheets are added.
After I open the workbook how I can find a specific sheet by using the name
on the Tab of the sheet?

Please help!

Thanks!


Reply
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
Find cell in Excel2000 workbook with link from another workbook? Mark4mmx Excel Discussion (Misc queries) 1 October 8th 08 12:55 PM
Find & Replace a link to another worksheet in the same workbook Sidesfive Excel Worksheet Functions 1 July 6th 06 10:23 PM
Find specific worksheet in another workbook and then applu Vlookup Salman Excel Worksheet Functions 0 March 22nd 06 09:03 AM
Find a value in a workbook and return the worksheet name Craig Excel Discussion (Misc queries) 2 August 10th 05 09:47 PM
copy worksheet from closed workbook to active workbook using vba mango Excel Worksheet Functions 6 December 9th 04 08:55 AM


All times are GMT +1. The time now is 10:03 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"