Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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
See more

1 reply

Answer 1 / 1

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!
Ask a question