Thread: [Solved] Pull the data from different closed workbooks paste into master vba
View Single Post
 
Old 11-14-2015, 11:43 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,387
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]