Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find cell in Excel2000 workbook with link from another workbook? | Excel Discussion (Misc queries) | |||
Find & Replace a link to another worksheet in the same workbook | Excel Worksheet Functions | |||
Find specific worksheet in another workbook and then applu Vlookup | Excel Worksheet Functions | |||
Find a value in a workbook and return the worksheet name | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |