|
|
#1
11-12-2015, 03:01 AM
|
|||
|
|||
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 |
| Tags |
| vba code |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 32bit 
Office 2007
Threaded Mode