Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 -- jijy ------------------------------------------------------------------------ jijy's Profile: http://www.excelforum.com/member.php...o&userid=15042 View this thread: http://www.excelforum.com/showthread...hreadid=553894 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
copying a cell that has a hyperlink | Excel Discussion (Misc queries) | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Removing hyperlink | Excel Discussion (Misc queries) |