Got It

=HYPERLINK("#'date details'!"&ADDRESS(ROW()+24,(COLUMN()+1)),'Date
Details'!C36)

"stew" wrote:

Hi all

In the following formula I would like ideally for the C
reference,HYPERLINK("#'date details'!C"&(( to change to D and E and F as I
drag the formula accross the columns. As the C is in the Inverted Commas it
does not change. Any Suggestions
=HYPERLINK("#'date details'!C"&((COLUMN()+34)),'Date Details'!C36)

Thanks for looking

Stew