Sheet 1 (date) has 300 pages, numbered fromtruck 1 to 300 with details
pertaining to specific information.

Sheet 2 ( Summary) has a breakdown of all the inofrmation from one page on
multiple lines, a summary report without all the nice letterhead and fancy
writing, just the basic information. Including the truck number from sheet 1
(data).

Now if I have to look up information I want ot be able to go to SUmmary
sheet, click on truck # 5 and it then take me exactly to Sheet 1 (data) Truck
5.

Now each truck is 60 cells apart from the first to the second if that helps.
So I need the hyperlink for... =data a60 truck 1 = data a120 truck 2... all
the way to 300.

Is there a easy way to do this, or do I have to do each one individually?




"Héctor Miguel" wrote:

hi, anonymous !

if you are "confused at work"... your post makes "confused" (this side of the news-reader)
could you provide a more... "accurated" details regarding your data layout ? (preferably, +/- exactly)

- what (and where) are the numbers in sheet1 ?
- how (and where) you need "hyperlink" in sheet2 to "the list" in sheet1 ?

regards,
hector.

__ OP __
I have a sheet with multiple numbers on it (Sheet1)
and... I have a tracking sheet of the numbers (Sheet2).
I want to be able to hyperlink from sheet 2 the list, to sheet 1 at the start of the page.
Sounds very easy, but I have 300 to do, wondering if there is a quick way to do it
or do I have to do everyone manually? Thanks.