Consolidate different workbooks into a new one [Closed]

Report
Posts
1
Registration date
Wednesday December 20, 2017
Status
Member
Last seen
December 20, 2017
-
 Blocked Profile -
Hi guys,
I have 3 excel workbooks (A, B, C) with multiple worksheets. Each one of the workbook have 2 worksheets (1, 2) with the same columns and same formatting.
This 2 worksheets are the ones that I'm interested on.

I need to have a new workbook (D) with 2 sheets (1,2) who consolidate the information of sheets 1 and 2 of workbooks A, B, C.
I need that everityme I open workbook D the new lines that I could possibly had add to files A, B and C appear in file D.
And that's it.

I know that I have to build a vba macro who copy all the info from sheet 1 of workbook A and when find a blank line stops and copy all the info from sheet 1 of workbook B and when find a blank line stops and copy all the info from sheet 1 of workbook C.
And the same for sheet 2.
But I don't realy know how to write the code...
Can anyone help me?

Thanks

1 reply


Take a look here:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba

See if there is an example in that article so that you can reverse engineer your own model!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!