Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another Hyperlink Question
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another Hyperlink Question
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 --------------- Jacob Skaria "stew" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another Hyperlink Question
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 "stew" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another Hyperlink Question
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 --------------- Jacob Skaria "stew" wrote: 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 "stew" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another Hyperlink Question
Thank you Jacob
Best regards Stew "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "stew" wrote: 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 "stew" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Hyperlink question | Excel Worksheet Functions | |||
hyperlink question | Excel Discussion (Misc queries) | |||
Hyperlink Question | Excel Discussion (Misc queries) | |||
hyperlink question | Excel Discussion (Misc queries) | |||
Hyperlink question | Links and Linking in Excel |