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

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

Hi Stew,

You can make a number of things to simplify the formula: where you are
using COLUMN()+1, just reference the column you want, if you are in column B
and you want to reference C see below. Also if the row number is constant,
then just enter its value:

=HYPERLINK("#'sheet2'!"&ADDRESS(36,COLUMN(C1)),She et2!C36)

I changed the worksheet name for testing purposes.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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