Hyperlink
I am working with a spreadsheet with two tabs of 1,000 rows. I would like to
hyperlink from one to the other. I can install a hyperlink in row one, but when I try to copy and paste for the next 999 rows, the link stays up on row one instead of following down the the next rows. Is there a way of propogating a hyperlink down the page without having to enter manually enter it in each cell? |
Hyperlink
Don,
Why not? "Don Guillett" wrote: Don't -- Don Guillett Microsoft MVP Excel SalesAid Software "Rooky228" wrote in message ... I am working with a spreadsheet with two tabs of 1,000 rows. I would like to hyperlink from one to the other. I can install a hyperlink in row one, but when I try to copy and paste for the next 999 rows, the link stays up on row one instead of following down the the next rows. Is there a way of propogating a hyperlink down the page without having to enter manually enter it in each cell? |
Hyperlink
Use a Hyperlink formula in an adjacent column.
The following formula links to the cell in Column B of Sheet2 that is in the same row as the hyperlink formula. The formula can be filled down or up. =HYPERLINK("[TestBook.xls]Sheet2!B" & ROW(),"Click Me") -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Rooky228" wrote in message I am working with a spreadsheet with two tabs of 1,000 rows. I would like to hyperlink from one to the other. I can install a hyperlink in row one, but when I try to copy and paste for the next 999 rows, the link stays up on row one instead of following down the the next rows. Is there a way of propogating a hyperlink down the page without having to enter manually enter it in each cell? |
Hyperlink
Jim, thank you! Works great.
"Jim Cone" wrote: Use a Hyperlink formula in an adjacent column. The following formula links to the cell in Column B of Sheet2 that is in the same row as the hyperlink formula. The formula can be filled down or up. =HYPERLINK("[TestBook.xls]Sheet2!B" & ROW(),"Click Me") -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Rooky228" wrote in message I am working with a spreadsheet with two tabs of 1,000 rows. I would like to hyperlink from one to the other. I can install a hyperlink in row one, but when I try to copy and paste for the next 999 rows, the link stays up on row one instead of following down the the next rows. Is there a way of propogating a hyperlink down the page without having to enter manually enter it in each cell? |
All times are GMT +1. The time now is 08:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com