Can I search sheet tabs for names?
 

I am using Excel spreadsheets to keep track of all my book authors and titles
-- so I don't duplicate. I have split them into two workbooks based on
author's name - A-L and M-Z. Still there are about 25-50 in each workbook.
Is there a way to search for the name on the sheet tab instead of scrolling
through them?

Can I search sheet tabs for names?
 

If you right click on the little arrows on the bottom left of your
spreadsheet, then you will see a list of the tabs in your workbook, and you
may well find this an easier way of looking at the names.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"kellerwynn7" wrote in message
...
I am using Excel spreadsheets to keep track of all my book authors and
titles
-- so I don't duplicate. I have split them into two workbooks based on
author's name - A-L and M-Z. Still there are about 25-50 in each
workbook.
Is there a way to search for the name on the sheet tab instead of
scrolling
through them?

Can I search sheet tabs for names?
 

Ken, thank you so much. Yes, that does help!!

"kellerwynn7" wrote:

I am using Excel spreadsheets to keep track of all my book authors and titles
-- so I don't duplicate. I have split them into two workbooks based on
author's name - A-L and M-Z. Still there are about 25-50 in each workbook.
Is there a way to search for the name on the sheet tab instead of scrolling
through them?

Can I search sheet tabs for names?
 

You're very welcome :-)

"kellerwynn7" wrote in message
...
Ken, thank you so much. Yes, that does help!!

"kellerwynn7" wrote:

I am using Excel spreadsheets to keep track of all my book authors and
titles
-- so I don't duplicate. I have split them into two workbooks based on
author's name - A-L and M-Z. Still there are about 25-50 in each
workbook.
Is there a way to search for the name on the sheet tab instead of
scrolling
through them?