Pull the data from different closed workbooks paste into master vba

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Pull the data from different closed workbooks paste into master vba

FAQ

Thread Tools

Display Modes

11-12-2015, 03:01 AM

manilara

Windows 7 32bit Pull the data from different closed workbooks paste into master vba

Office 2007

Banned

Join Date: Apr 2015

Posts: 7

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

	Month_Jan.xlsx (10.6 KB, 11 views)
	Master.xlsx (11.1 KB, 10 views)
	Month_FEB.xlsx (13.3 KB, 10 views)

Tags

vba code

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to Pull Data From Multiple Files	Jess709	Excel Programming	30	05-20-2015 05:26 PM
Macro to pull data out of a Word table	shanemarkley	Word VBA	20	05-07-2015 01:36 PM
Linking Workbooks/Entire Worksheets to Identical in Master	taxacct	Excel	2	10-01-2014 11:22 AM
Excel VBA: Pull data from web	tinfanide	Excel Programming	0	12-09-2011 02:11 AM
macro to pull data from multiple files	psrs0810	Excel	2	10-25-2010 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:33 PM.