I work in sales and I have a list of schools that I do business with.
In the spreadsheet it has the school name, tel number, postcode address etc.
I have notes for each account or line in notepad documents on my PC.
I need to be able to link all of the correct notes to the respective...
Right now I specify a hyperlink between a table of contents and a workbook by using the cell destination name.
Is there a way to make it so the hyperlink will move if lines are added or subtracted? Right now I have to manually move over 350 link locations.