Split Excel report and save separate Workbooks to respective locations

I'm trying to figure out a way to modify my macro so it can use another Workbook with a list of file locations to save in the respective location. This macro below splits a large report file into separate files based on common values in column A. These values are location codes that are also in column A in my other Workbook containing the file folder locations in column C.
*
I receive these reports daily and have to manually put each file into their dropbox locations, which I imagine can be done easily with a little more code. I'm stumped. I've tried another while loop and if statements. Ideally, I will open my report file, open the macro file, open the dropbox file, run the macro and the file will split up and go to their respective locations.
*
*

Please Login or Register  to view this content.