|
|
#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 |
|
#2
11-14-2015, 11:43 PM
|
||||
|
||||
|
The inconsistent structure of your monthly workbooks makes consolidation more difficult than it need be. Whereas your Jan workbook has data in column A, your Feb workbook has the corresponding data in column B. It is unreasonable to expect a formula or macro to handle such inconsistencies.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
#3
11-19-2015, 08:41 PM
|
||||
|
||||
|
Cross-posted at: http://www.mrexcel.com/forum/excel-q...ml#post4338911
and: http://www.excelguru.ca/forums/showt...rom-masterdata and: http://www.excelforum.com/excel-prog...aster-vba.html and: http://www.ozgrid.com/forum/showthread.php?t=197510 and: http://excelexperts.com/pull-data-di...ste-master-vba For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184 Thread closed
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
| Tags |
| vba code |
|
|
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
Linear Mode
