Another combining multiple workbooks to a single one!

  • I have 12 workbooks, and in each workbook there are five sheets of data (say sheets called alpha, bravo, charlie e.t.c), all data in sheets have common column titles. Is there a fast way of collating all this into 5 sheets in a single workbook? i.e listing all Alpha data on a single sheet, all bravo data on a single sheet ...etc etc.

    Thanks in advance


  • You can do this by using New Database Query, using excel file.

    I tried it with 6 sheets Jan -> Jun and it did work for me.

    I have recorded the macro of the procedure...

    The key here is to change the query to "SELECT * from ...... Union All Select * from .... "

    see the code below......

    As told earlier, this is the code generated automatically.... if you want you can also try recording one and then modify as you wish :)

    Hope this helps. Let me know if this does not work.

    Thanks: ~Yogendra

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!