Multiple Hyperlinks in Excel 2010

HELLBILLY

New Member
Joined
Sep 11, 2014
Messages
1
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.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,108,509
Messages
5,523,313
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top