I have a workbook named RetailClientTemplate which contains sheets named by
locale abbreviation (EN, ES, DE, IT, etc.). I have workbooks named
RetailProjectLog_DATE generated each day that are saved into a specific
folder location. Each row in each RPL workbook has a locale in column A that
matches the name of one of the sheets in the RCT workbook. What I need to do
is make a macro that will copy & paste the rest of the data from each row in
each of the RPL books (sheet1, range B4:Q200, and col P data separately) in
the specified folder into the corresponding sheet for each locale in the RCT
workbook (row by row, starting at A12:P12, and data from col P in RPL into
col Y in RCT). How can this be done? And is it possible to do it without
visibly opening each of the RPL workbooks top copy the data from them? Please
help. The boss is really breathing down my neck on this one and I can't
figure it out! Thank you!