Pull the data from different closed workbooks paste into master vba

Status
Not open for further replies.
M

manilara

New member
Joined
Nov 5, 2011
Messages
10
Reaction score
0
Points
0
Location
sydney
Excel Version(s)
2019
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
 

Attachments

  • Month_Jan.xlsx
    10.6 KB · Views: 11
  • Month_FEB.xlsx
    13.3 KB · Views: 7
  • Master.xlsx
    11.1 KB · Views: 9
manilara,
I have asked you before to be considerate and to supply links when cross posting. You have ignored this.
If you don't want this thread closed like this one, I suggest you add links to where you have cross posted as quickly as possible.

To others considering helping manilara, I woul prefer that you wait until manilara has added links before doing so.
 
sorry sir i want immediate solution that why i posted here...how to delete post please advice me
 
I can delete it for you, but why don't you just supply the links to where you have cross posted?

Thread closed
 
Last edited:
Status
Not open for further replies.
Back
Top