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?

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?

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?

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?