I am struggling with an excel data processing problem. I have 400 excel workbooks for different Customers containing no data. I have one excel data file exported from an internal system. For each Customer file I need to paste in the corresponding data from the data file.
Please note: The Customer name is in the title of the Customer excel file and the Customer name is available in column E of my data file for matching purposes.
Lastly, I need to click a macro button and save the file to a specific folder based on pass or failure of the macro check.
Could someone help me get started with this activity?