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
Reply from Alex Hedley:
That's quite a big task, what have you tried so far?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
