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