Hi All,
Last question from me for the day. I am adding a ton of Hyperlinks to a massive work book. The book has a master sheet with totals from all other sheets. I am setting it up to link from th master sheet to the espective property sheet (all in same workbook). for Example, Sheet 1 Cell A1 has a Hyperlink to Sheet 2 Cell Z186. I thne have Sheet 2 Cell Z186 Linked back to Sheet 1 Cell A1. I am doing this for navigation through this big workbook for the users.
Is there a way, that when i creat the Hyperlink in Cell A1 (sheet 1) and point it to Cell Z186, that it automatically makes Cell z186 point back to CellA1, so that i do not have to duplicate the step for every link? Any help would be greatly appreciated!!
thanks in advance
Last question from me for the day. I am adding a ton of Hyperlinks to a massive work book. The book has a master sheet with totals from all other sheets. I am setting it up to link from th master sheet to the espective property sheet (all in same workbook). for Example, Sheet 1 Cell A1 has a Hyperlink to Sheet 2 Cell Z186. I thne have Sheet 2 Cell Z186 Linked back to Sheet 1 Cell A1. I am doing this for navigation through this big workbook for the users.
Is there a way, that when i creat the Hyperlink in Cell A1 (sheet 1) and point it to Cell Z186, that it automatically makes Cell z186 point back to CellA1, so that i do not have to duplicate the step for every link? Any help would be greatly appreciated!!
thanks in advance
