HYPERLINK!!!

[Confused at Work]

I have a sheet with multiple numbers on it ( Sheet1), and on another sheet I
have a tracking sheet of the numbers(Sheet 2). 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.

 

[Héctor Miguel]

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 __

 

[Confused at Work]

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]

hi, !

in sheet2, starting on A1, use the following formula (and copy/drag 300 rows down)

=hyperlink("#sheet1!a"&row()*60,"summary of truck "&row())

modify/adapt/... according your (real) layout, sheet-name, ...

hth,
hector.

Sheet 1 (date) has 300 pages, numbered from truck 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?

__ OP __

 

[Confused at Work]

Hector.


Data (Sheet)

D7 - 1 (Truck #)
in between has all information pertaining to that specific truck
D67 - 2 (Truck #)
information
D127 - 3 (Truck#)
so on so son until 300

----------------------------------------------------

Summary (Sheet)

Truck Weight Ref Ect..
A4 1 123.00 15
A5 2 110.00 13
A6 3 1000.0 18
A7 4 100 5
so on so to 300

Want to be able to click on Summary Sheet A4, and that take me exactly to
Data Truck #1 and so on til 300.

 

[Héctor Miguel]

hi, !

in summary sheet, adapt previous proposed formula as follows:

from: [A1] =hyperlink("#sheet1!a"&row()*60,"summary of truck "&row())

to: [A4] =hyperlink("#data!d"&rows(a$4:a4)*60+7,"info of truck "&rows(a$4:a4))

hth,
hector.

__ OP __

 

[Héctor Miguel]

hi, (again), !

in summary sheet, adapt previous proposed formula as follows:

from: [A1] =hyperlink("#sheet1!a"&row()*60,"summary of truck "&row())

to: [A4] =hyperlink("#data!d"&rows(a$4:a4)*60+7,"info of truck "&rows(a$4:a4))

sorry, i have a mistake in revised formula, try this new one:

[A4] =hyperlink("#data!d"&(rows(a$4:a4)-1)*60+7,"info of truck "&rows(a$4:a4))

hth,
hector.