|
Can I fill cells with a hyperlink
I am trying to put a hyperlink in or beside cells on one sheet to bring me to
the same cell on another sheet I have used =HYPERLINK("#'Notes'!A1","jump"). Notes being the sheet name I want it to jump to and it works but is there any way I can get the A1 in the formula to change to A2 etc (relatively) when I fill cells as I want about 6000 rows to have a hyperlink beside them to jump to corrosponding cell on the Notes sheet. Thank You in advance or maybe there is an easier way to do this Mary jump Joe jump Jim jump Sean jump Nora jump Paul jump Mary jump Joe jump Jim jump Sean jump Nora jump Paul jump Mary jump Joe jump Jim jump Sean jump |
Can I fill cells with a hyperlink
Ber,
=HYPERLINK("#'Notes'!A" & ROW(),"jump") HTH, Bernie MS Excel MVP "Ber" wrote in message ... I am trying to put a hyperlink in or beside cells on one sheet to bring me to the same cell on another sheet I have used =HYPERLINK("#'Notes'!A1","jump"). Notes being the sheet name I want it to jump to and it works but is there any way I can get the A1 in the formula to change to A2 etc (relatively) when I fill cells as I want about 6000 rows to have a hyperlink beside them to jump to corrosponding cell on the Notes sheet. Thank You in advance or maybe there is an easier way to do this Mary jump Joe jump Jim jump Sean jump Nora jump Paul jump Mary jump Joe jump Jim jump Sean jump Nora jump Paul jump Mary jump Joe jump Jim jump Sean jump |
Can I fill cells with a hyperlink
Thank you Bernie you are a star
"Bernie Deitrick" wrote: Ber, =HYPERLINK("#'Notes'!A" & ROW(),"jump") HTH, Bernie MS Excel MVP "Ber" wrote in message ... I am trying to put a hyperlink in or beside cells on one sheet to bring me to the same cell on another sheet I have used =HYPERLINK("#'Notes'!A1","jump"). Notes being the sheet name I want it to jump to and it works but is there any way I can get the A1 in the formula to change to A2 etc (relatively) when I fill cells as I want about 6000 rows to have a hyperlink beside them to jump to corrosponding cell on the Notes sheet. Thank You in advance or maybe there is an easier way to do this Mary jump Joe jump Jim jump Sean jump Nora jump Paul jump Mary jump Joe jump Jim jump Sean jump Nora jump Paul jump Mary jump Joe jump Jim jump Sean jump |
| All times are GMT +1. The time now is 04:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com