Macro for copying from separate workbooks to the mother-workbook

[adinutzaa]

Hello,
Could someone help me with the VB code for a macro that copies information from multiple workbooks into a main workbook, in the same (corresponding) columns/cells - all workbooks involved (main and secondary) having the same structure, same databases, same number of worksheets which are named the same?
Basically, what I'd like to do is consolidate the data that has been filled in multiple versions of one main workbook (so from separate workbooks that have the same structure as the main workbook), into that main workbook... so that information from certain columns from the secondary workbooks be pasted into the corresponding columns of the main workbook (but only where corresponding cells within the main workbook are empty - so that we avoid pasting blank information from the secondary workbooks over non-empty cells within the main workbook).
The workbooks have several worksheets.
I am a rookie with VB... my hope is to find some enlightment here
Thank you!

[arthurbr]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.