Thread: [Solved] Pull the data from different closed workbooks paste into master vba
View Single Post
 
Old 11-12-2015, 03:01 AM
manilara manilara is offline Windows 7 32bit Office 2007
Banned
  
Join Date: Apr 2015
Posts: 7
manilara is on a distinguished road
Default Pull the data from different closed workbooks paste into master vba
Dear Experts

I have multiple workbook saved in folder i want copy data from closed books and paste into mastersheet particular criteria is
sum the column F:F and average the column G:G after 20th rows

copy from
Month_FEB.xlsx
Month_JAN.Xlsx
Paste Into
Master.xlsx


Path is C:\Users\maninata\Desktop\Personal\Excelforum\VBA\ TASK_1

Find the attachment
Attached Files
File Type: xlsx Month_Jan.xlsx (10.6 KB, 11 views)
File Type: xlsx Master.xlsx (11.1 KB, 10 views)
File Type: xlsx Month_FEB.xlsx (13.3 KB, 10 views)