Copy paste of sheets from a folder

[vmjan02]

Have check many codes and have browed web but help less.

I have a master file with sheet names "Client Wise Revenue Tracking" and "Manpower Costing"

I have a folder by name "Daily Performance Downloaded Files" this folder has more than 1 excel file

The code should
1) go to folder "Daily Performance Downloaded Files"
2) Open a file - "There are more than 10 files"
3) Copy user.range from sheet ""Client Wise Revenue Tracking"
4) Paste the data as values in master excel file sheet ""Client Wise Revenue Tracking"
5) Then copy user.range from sheet ""Client Wise Revenue Tracking""
6) Paste the data as value in master excel file sheet ""Client Wise Revenue Tracking"
7) close the open file from folder
8) Now repeat steps 1 to 7 (Copy paste of sheets must appended for both the sheets)

eg:- in a folder there are 10 files, so it will open file1.xls then will copy used.range cell from sheet "Client Wise Revenue Tracking"
and will paste values in master file sheet "Client Wise Revenue Tracking"
and then from same file1.xls will copy user.range from sheet "Manpower Costing" and will past in master file sheet ""Manpower Costing"
and will close file1.xls

After copy past sheets it will open file2.xls from folder and do the copy and paste for both the sheets but in master file sheets it will append data from file1.xls, file2.xls and so on

I hope have explained in it as much as possible

Is there a VBA way..

 

[vmjan02]

Hi There, any update on it.