Hyperlink to the same date in another sheet

Hi

I have a workbook with many sheets. All sheets have sequential dates in column A, 1 row per day, looking backwards in time as well as forwards.

NB NB The sheets do not necessarily all start on the same date, so 1/1/2019 might be cell A999 in Sheet1 , but cell A600 in Sheet2.

I want to hyperlink from a cell, say F999 in Sheet1 to the same date in Sheet2, ideally cell F600 (but any cell in row 600 would do).

I've looked up Hyperlink on Google but sadly I really don't understand. Can it be done? , and if so how?

Many thanks as always

Trebor

Hi again & thanks for this. I assume the "filename" needs the full pathname of the file ? ie C:/etc/etc ??

Why F6 I don't understand??

Thanx again Trebor

Thanks again. My dates are in column A, so I changed all your F6 to A6. Also Sheet2!F to Sheet2!A, and Sheet2!F:F to Sheet2!A:A.
I pasted it into cell W6 (the 1st free column) in Sheet1. I get a #name error.

I can't send a copy of the worksheet as it's very confidential.

I will double-check and get back to you.

Trebor

I think I understand, my cell F999 that I used in the question is a random cell in row 999, the dates are in cell A999

Thanx again, my workbook is saved to the C: drive, in MyDocuments.

I will check out your download tomorrow as it's late & I have to log off soon. Trebor

Another way

=HYPERLINK("#"&"Sheet2!A"& MATCH(A2,Sheet2!A:A,0),"Link")

Decio

Hi & thanks, I assume this needs to go into a spare column in row 2, sheet1 ??

Originally Posted by Trebor777

Thanx again, my workbook is saved to the C: drive, in MyDocuments.

I will check out your download tomorrow as it's late & I have to log off soon. Trebor

Hi again. Your book works fine. I am beginning to think that the problem at this end is due to my sheet (tab names)

The example I sent used Sheet1 and Sheet2 as tab names. My actual Sheet2 is actually called 'Aaa. Bbb', with a space in the middle. It works fine in my workbook, but I wonder is it OK in your solution?

I can change the sheet name no problem, it will take a while, as many other sheets link to it.

Am I right in assuming this is the issue ?

Many thx for all your support

Trebor

In this case use this way

Decio

This works, thanks both, I'd missed the single quotes.