Another Hyperlink Question

  • Thread starter Thread starter stew
  • Start date Start date
S

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
 
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
 
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
 
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
 
Thank you Jacob

Best regards

Stew

Jacob Skaria said:
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
Click to expand...
 
Back
Top