Another Hyperlink Question

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
 
J

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
 
S

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
 
J

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
 
S

stew

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top