I have an Excel file with a large number of records (rows). Each row will be linked to a separate external source file.

I'm trying to setup a macro that will quickly create and change the external path for each row of data. All of the rows in my Excel file are consistent with the only difference being their source file. And the external source files are all similar to one another. So the only thing that's changing is the path. Is there an easy solution to this problem?