Another Hyperlink Question

[stew]

Hi all

=HYPERLINK("#'a5","View")

In a5, on the same work sheet and row as this Formula, is a date 08 February
2010.

08 February 2010 is also the name of a work sheet in this work book. I am
try to have a formula that takes me to worksheet 08 February 2010. Also when
I draw this formula down it goes A6 which contains 09 February 2010
A7 which contains 10 February 2010
A8 which contains 11 February 2010
A9 which contains 12 February 2010
ETC
These are all names of Worksheets

Hope I have made this Clear. Obviously the above Formula is not doing the Job

Help

Thanks

Stew

 

[Jacob Skaria]

With

A5 = 08/02/2010 (excel date format)

Try the below formula. Drag the dates&formula down

=HYPERLINK("#'" & TEXT(A5,"dd mmmm yyyy")& "'!A1","View")

If this post helps click Yes

 

[stew]

Dear Jacob

Thank You that works a treat.

So if I wanted to add "transfer" to that would it be

=HYPERLINK("#'" & TEXT(A11,"dd mmmm yyyy")&" "&"TRANSFER"& "'!A1","View")
I would like to access worksheet 14 February 2010 Transfer

Best

Stewart

 

[Jacob Skaria]

You can try..(a bit shorter)..Strings within double quotes can be together//

=HYPERLINK("#'" & TEXT(A11,"dd mmmm yyyy")&" TRANSFER'!A1","View")

If this post helps click Yes

 

[stew]

Thank you Jacob

Best regards

Stew

You can try..(a bit shorter)..Strings within double quotes can be together//

=HYPERLINK("#'" & TEXT(A11,"dd mmmm yyyy")&" TRANSFER'!A1","View")

If this post helps click Yes