Copy paste of sheets from a folder

vmjan02

Well-known Member
Joined
Aug 15, 2012
Messages
774
Office Version
  1. 2013
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..
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,176,002
Messages
5,900,799
Members
434,854
Latest member
ExcelMuffin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top