Hyperlink Question

S

stew

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
 
S

stew

Got It

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

Shane Devenshire

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)),Sheet2!C36)

I changed the worksheet name for testing purposes.
 

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

Similar Threads

IFBLANK 2
If then formula with multiple cells 2
Exchanging data 1
Problem with SET & REF function 0
File name question 0
understading function 6
Help with Formula 3
Another Hyperlink Question 4

Top