Merge Workbooks

[gjadcock]

Guys,

I have approx 15 txt files which I have written VB code to import into excel and format, text to columns etc and save as xls.

I need some code that will merge the files together into one master sheet in a seperate workbook.

All the xls sheets have the same number of columns but the row counts are different so I need to find the last row of data, copy this and paste into the next available row in the master sheet.

Any Ideas

Thanks

 

[attc]

I haven't seen a reply to this. Not sure if you found a solution already, but if not you'll find the following helpful:

http://j-walk.com/ss/excel/tips/tip10.htm