Hey, i'm stumped!

I've got two worksheets in a workbook, and i excel to automatically
create a link so when i doubleclick on a cell on one sheet, it will
take me to the second sheet and to the correct row.

E.g.
sheet one has a list of customers down the left, and dates across the
top.
it is used to record what product each customer orders on a particular
day, by cross referencing the customer name with the date and entering
the appropriate product code in that cell.

sheet two has a list of product codes down the left, and product
information across the top (type, desc, etc.).


I need excel to automatically set up a link, so that no matter what
code is entered on the customer sheet, when i click / double click, it
will take me to the corresponding row on the product sheet.


I've been messing around with lookup tables and stuff, but i cant find
a way of doing it. Anybody???


Thanks

GoJo


--
gareth93
------------------------------------------------------------------------
gareth93's Profile: http://www.excelforum.com/member.php...o&userid=26578
View this thread: http://www.excelforum.com/showthread...hreadid=551835