Merge data from different workbooks
 

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

Merge data from different workbooks
 

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Obonden" <kjeblo(æt)frisurf.no wrote in message ...
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