Pull the data from different closed workbooks paste into master vba

M

manilara

New Member
Joined
Feb 3, 2013
Messages
11
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
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Macro to open multiple workbooks and copy a range of data based on todays date. Then paste the data in master workbook in one sheet under each other.
Replies
8
Views
592
Luke1690
L
S
  • Question Question
Gathering Data From Multiple Files in Same Folder in Particular Range
3 4 5
Replies
41
Views
1K
kvsrinivasamurthy
K
B
  • Question Question
Copy and paste from one worksheet into a new workbook and save to a particular directory
Replies
3
Views
559
Joe4
Joe4
R
  • Question Question
VBA to pull data from closed workbooks
Replies
3
Views
995
Logit
Logit
S
  • Question Question
VBA Copy/Paste from different workbooks
Replies
1
Views
360
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,223,723
Messages
6,174,121
Members
452,545
Latest member
boybenqn

Share this page

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
Back
Top