Merge data from different workbooks

O

Obonden

I have 8 workbooks similar-looking workbooks (with the same formats and
columns). I want to merge the content from these workbooks into a 9th
workbook. This 9th workbook is already established and I have defined some
formats and macrobuttons in this workbook. I want the data to be merged into
this workbook, and not into a new workbook as described at
http://www.rondebruin.nl/copy3.htm. (May be you have described the solution
at your pages, Ron, but I couldn't find it, and my macro-"programming" is
based on cut and paste without understanding very much...)

Kjell
 
R

Ron de Bruin

Hi Kjell

Open the 9th workbook and copy the macro in that workbook

You see this line in the code
'Add a new workbook with one sheet
Set BaseWks = Workbooks.Add(xlWBATWorksheet).Worksheets(1)

Then change the code line to
Set BaseWks = Thisworkbook.Worksheets("Sheet1")
Change the sheet name to yours
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top