Excel VBA Save to Path Based on Cell Value 

This video displays how to Save a Copy of a file to Multiple Path Locations based on a Single Cell Value in your Worksheet in VBA. This is achieved by inserting a VLOOKUP formula in this single cell that performs a lookup to a table containing the multiple paths. This enables the user to link multiple paths to this single cell in the VBA Code via one single variable.
#ExcelVBASaveFileToPathBasedOnCellValue