All Gurus,
Thanks for the help you have all given me thus far. I am curious
about a type of menu that I can put on top ( cells b1 thru aa1 are
open) of a current work sheet that has Hyperlinks from over 100 other
sheets to it. They all go to A1 in this sheet and what I would like
is an alphabetical menu either by name or first 3 letters for column A
since this is the data I want to go to quickly. Other cells in this
column include numbers and the words UPC Code that repeats under each
name. Is there sometihing I can create instead of always ending up at
A1 and scrollling or paging down?

Thank you in advance

in the help box type SHORTCUT. Look at workbook and worksheets

" wrote:

All Gurus,
Thanks for the help you have all given me thus far. I am curious
about a type of menu that I can put on top ( cells b1 thru aa1 are
open) of a current work sheet that has Hyperlinks from over 100 other
sheets to it. They all go to A1 in this sheet and what I would like
is an alphabetical menu either by name or first 3 letters for column A
since this is the data I want to go to quickly. Other cells in this
column include numbers and the words UPC Code that repeats under each
name. Is there sometihing I can create instead of always ending up at
A1 and scrollling or paging down?

Thank you in advance