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