J
jijy
In Sheet1, cell A1 has the formula=Sheet2!B3. Cell A1 (Sheet1) also
contains a hyperlink that is linked to Sheet2!B3
Now what I want to do is to copy the formula & the hyperlink in
sheet1A1 down to cell A2 and all the way to cell A250.
The issue is when I do the copy, the formula is copied but the
hyperlink still points to Sheet2!B3.
Any thoughts or ideas?
Thanks a lot.
Jijy
contains a hyperlink that is linked to Sheet2!B3
Now what I want to do is to copy the formula & the hyperlink in
sheet1A1 down to cell A2 and all the way to cell A250.
The issue is when I do the copy, the formula is copied but the
hyperlink still points to Sheet2!B3.
Any thoughts or ideas?
Thanks a lot.
Jijy