Good afternoon, I have several worksheets that are pulling information from a
company drive, the worksheets are pulling information from several sources
but the sources are all saved with the same path/name from period to period
w/ the exception of the period # (i.e. period 1, period 2 etc). Right now I
am performing a control + F to replace all of the data when new data is saved
on the company drive for each individual worksheet, is there a way to write a
macro to replace the old info with the new?