How to add Hyperlinks of multiple folders to multiple lines of a spreadsheet.

[StuperDuper]

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 accounts, rather than add the hyperlinks one by one, can anobody please let me know how to link them in one go?

Thanks

 

[Andrew Poulsom]

If you have the path to the text file for each school you can use the HYPERLINK function.