| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I drag a hyperlink series to fill instead of copy? | Excel Worksheet Functions | |||
| Can I create a hyperlink to another page and then FILL series? | Excel Worksheet Functions | |||
| Fill cells with color based on criteria in two cells | Excel Worksheet Functions | |||
| create a fill in template to tab to fill in cells | Excel Discussion (Misc queries) | |||
| HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? | New Users to Excel | |||
Linear Mode
