[dbertsch4]

I am not sure how to go about this macro. I am trying to produce a hyperlink in a column (equipment info) but as it goes down a row change the hyperlink to reflect its file name that is found in a different column.

so the hyperlink location is "\\SNOGP01\poshare\PoShare\North Omaha System Files\10 Year Mechanical Plan, major plant equipment\1AC-1A Info & Name Plate.docx"

The next one down would need to change the "1AC-1A" to "1AC-1A-M"

Any help is much appreciated.