#1. Yep. The program has to know where to jump for each part number. But they
don't have to be unique "jump to" locations. You could have multiple part
numbers jump to the same location--maybe a header cell for that type of tool.
(All hammers go to the hammer "jump to" point--no matter the actual type.)

#2. Column B would hold Cate002. But you'd have a name Cate002
(insert|Name|define) that pointed at retail!a2. So it sounds like you got what
I meant.

===
And alternative would be to use a macro that would look at the part number and
then search all the sheets looking for that part number. The macro could be
invoked by a worksheet_event (dependind on the version of excel you're using) or
maybe even a button that the user clicks.



Brisebear wrote:

Thanks for the reply Dave, I have tried it, but there are some teething
problems, which hopefully you can iron out for me with some
clarifications:

1. When you say "Create range names for each of these locations", do
you mean for each individual "tool number" for for the tools located in
specific worksheets?
2. When you suggest that Column B be the location you need to jump to,
do you mean that I can do a cell reference by, for example selecting
Cate002 and referencing it by going "=Retail!A2" or does it have to be
set up in a different manner?

I look forward to your advise as so far it is the closest I have come
to resolving this issue.

Brian.:)

--
Brisebear
------------------------------------------------------------------------
Brisebear's Profile: http://www.excelforum.com/member.php...o&userid=37689
View this thread: http://www.excelforum.com/showthread...hreadid=572958

--

Dave Peterson