|
|
#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] |
| 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 64bit 
Office 2010 32bit
Threaded Mode