I have an Excel Workbook that has approximately 200 sheets in it. What I am trying to do, for example, say I have two sheets that are essentially identical. On sheet one I want to create hyperlinks to the same cell in sheet 2. I know how to do it one at a time, but I would like to do is be able to copy the hyperlink and have it paste in the same way a formula would.
If I have a hyperlink in sheet one, cell A1 and create a hyperlink to sheet 2, cell A1, I want to be able to copy it accross a range in sheet one and have the pasting of the hyperlink now reference the coresponding cell in sheet two. In other words, if I copy cell A1 in sheet one and paste it to cells A2:A10, the hyperlinks in each cell when clicked will take me to the identical spots in sheet 2.
Any assistance is greatly appreciated.
If I have a hyperlink in sheet one, cell A1 and create a hyperlink to sheet 2, cell A1, I want to be able to copy it accross a range in sheet one and have the pasting of the hyperlink now reference the coresponding cell in sheet two. In other words, if I copy cell A1 in sheet one and paste it to cells A2:A10, the hyperlinks in each cell when clicked will take me to the identical spots in sheet 2.
Any assistance is greatly appreciated.
