Hi Everyone!
I have to copy data from workbook1 to workbook2. I extract Workbook1 in our reporting site while Workbook 2 is located on my desktop: C:\Users\ABC\Desktop\Excel Report\
After extracting Workbook1, I need to select data range C4:AP52 in sheet1 (sometimes the range varies depending on how long the historical data. i.e. I extracted data from Dec.1, 2020 - Feb. 9, 2021, but most of the time I only extract 6 weeks worth of data - Jan.1, 2021 - Feb. 9, 2021). After selecting the data, I will now copy and paste it to Workbook2 - sheet1 C4. Then move to Workbook1 sheet2 and do the same process I did for sheet1. The process continue until all sheets from Workbook1 are copied to the sheets of Workbook2.
I have tried looking in the web if there's already an existing VBA macro that I can use but failed to find one. I'm not really good with VBA and any help is really appreciated.
Please let me know if you have any question or clarification.
I have to copy data from workbook1 to workbook2. I extract Workbook1 in our reporting site while Workbook 2 is located on my desktop: C:\Users\ABC\Desktop\Excel Report\
After extracting Workbook1, I need to select data range C4:AP52 in sheet1 (sometimes the range varies depending on how long the historical data. i.e. I extracted data from Dec.1, 2020 - Feb. 9, 2021, but most of the time I only extract 6 weeks worth of data - Jan.1, 2021 - Feb. 9, 2021). After selecting the data, I will now copy and paste it to Workbook2 - sheet1 C4. Then move to Workbook1 sheet2 and do the same process I did for sheet1. The process continue until all sheets from Workbook1 are copied to the sheets of Workbook2.
I have tried looking in the web if there's already an existing VBA macro that I can use but failed to find one. I'm not really good with VBA and any help is really appreciated.
Please let me know if you have any question or clarification.