I have several reports that are generated and spit into excel after a
quick macro they wind up in the same workgroup on three spreadsheets.
basically one spreadsheet has the main list with short info, and the
other two sheets have the detailed info. I will probably end up
combining the info of the two sheets into one, they are both exactly
the same but for different customers.

basically i was wondering if there is a way that i can create a
hyperlink that when the user clicks on the order number in the short
info page it takes him to that order number on the detail info page.

i know you can create hyperlinks to certain worksheets but is there a
way to take a user to a specific cell or row.


i hope that isn't too confusing


--
trav
------------------------------------------------------------------------
trav's Profile: http://www.excelforum.com/member.php...o&userid=31420
View this thread: http://www.excelforum.com/showthread...hreadid=520341