Copy a formula

  • Thread starter Thread starter pcorcele
  • Start date Start date
P

pcorcele

=HYPERLINK("[hooks.xlsm]Sheet2!a1","CLICK HERE")
I have the above formula in sheet1, c3
I would like to drag it down to a100 so that the next line would read
=HYPERLINK("[hooks.xlsm]Sheet3!a1","CLICK HERE")
and the next line
=HYPERLINK("[hooks.xlsm]Sheet4!a1","CLICK HERE")
all the way to 100
thanks
 
pcorcele wrote :
=HYPERLINK("[hooks.xlsm]Sheet2!a1","CLICK HERE")
I have the above formula in sheet1, c3
I would like to drag it down to a100 so that the next line would read
=HYPERLINK("[hooks.xlsm]Sheet3!a1","CLICK HERE")
and the next line
=HYPERLINK("[hooks.xlsm]Sheet4!a1","CLICK HERE")
all the way to 100
thanks
Click to expand...

Try this, may be it works.

=HYPERLINK("[hooks.xlsm]Sheet"&ROW(A1)&"!a1,CLICK HERE")

Bruno
Click to expand...

Thnaks but it does not work
 
Back
Top