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