Hi,
I have a excel spreadsheet with multiple hyperlinks that I need to change (about a 3000 lines)
I have a range of ref# e.g. 10000 - 90000, every ref# has 5 files e.g. 10000 A, 10000 B, 10000 C, 10000 D, 10000 E, and then thousands of ref #.
I need to hyperlink these ref # and to the corresponding files in a folder, but do not want to do it manually as it would take forever. I have managed to get the hyperlinks (name) to display what the ref# is but cannot find a way to change the address of the hyperlink accordingly... any help would be greatly appreciated.
I have a excel spreadsheet with multiple hyperlinks that I need to change (about a 3000 lines)
I have a range of ref# e.g. 10000 - 90000, every ref# has 5 files e.g. 10000 A, 10000 B, 10000 C, 10000 D, 10000 E, and then thousands of ref #.
I need to hyperlink these ref # and to the corresponding files in a folder, but do not want to do it manually as it would take forever. I have managed to get the hyperlinks (name) to display what the ref# is but cannot find a way to change the address of the hyperlink accordingly... any help would be greatly appreciated.