Good morning, brilliant and generous people!
I am looking for help for the following:
I have the file Employeea.xls that has the macro "CombineAllDays". [This Macro copies the data from all the sheets in the workbook, creates a new sheet called "Master", and pastes the copied data in there.]
I have GetData.xls file that opens Employeea file, copies the data from "Master" sheet in Employeea file and pastes it into a sheet called "Retrieved Data" in the GetData file.
Question: How can I get "GetData" macro to run "CombineAllDays" macro in Employeea file first after opening the workbook and before copying the data?
Thank you in advance for any help. Enjoy your Sunday!
Bookmarks