I have a master worksheet with a column of cells all containing hyperlinks to website. I need to update these yearly (because they change).
In other worksheet in the excel spreadsheet I have to set up other combinations of the hyperlink cells. therefore I’d like to link to the cells in the master worksheet. I know how to copy the hyperlinks, but I would like to link to the hyperlink cells so that the link is updated in the new worksheets when I update the master worksheet. is this possible?