Hi,

I have an Excel Report where the raw data copy-paste needs to be automated using VBA code;

Below is the requirement in detail:
The location of the raw data will be changed every week; I will have to input this;

There will be 4 subfolders in the location and 3 excel files in each subfolder; it has to pick up each one of these excel files, open relavant sheet/tab in the main report, select appropriate range, delete the existing data & then paste the new data;

(names of sub folder & the excel files in it will remain constant)

Can anyone help me with the above please?