how to combine several files, all with same columns, into one shee

[Ron de Bruin]

Hi

Rows with a blank cell in a column or a whole blank row ?

After you merge the data into a new sheet you can loop through all rows or filter os sort.
For deleting rows see
http://www.rondebruin.nl/delete.htm

 

[Guest]

Hi Ron,
The column may have a blank row in it. When I use the macro it stops at the
blank row and moves to the next file. Sometime the blank row is in the middle
of the file. Is there a way for the macro to skip the blank row and continue
copying the rest of the column?

 

[wal50]

Bernie's code works for me but I have two questions:
It works in a new worksheet (as directed) when I tried to move it to
Personal.xls, I can't get it to work. It runs with a blank result. Is this
pilot error or is there a fix?

Can the code be modified to combine .csv files?
.FileType = msoFileTypeExcelWorkbooks
=msoFileTypeCoomaSeparatedValues. N/G

Thanks for your help. A great resource.
wal50

 

[Ron de Bruin]

It paste to

ThisWorkbook.Sheets(1).Range("A65536").End(xlUp)(2)

ThisWorkbook = your personal file now

For csv this is also a option
http://www.rondebruin.nl/csv.htm

Or use my add-in
http://www.rondebruin.nl/merge.htm

 

[wal50]

Worked like a charm. Thanks again to you and all the other wizards who make
the lives of mere mortals that much easier.
wal50

 

[Alawi]

Great Ron,
Entering A2 in startCell will remove any header. But what if I need to keep
the header to be in the first row of the new sheet and not repated from every
file I combine?

 

[Graham@BDS]

In the process of helping clients manage their spreadsheets I have developed
a web application that loads, organizes and reports upon a portfolio of
spreadsheets.
This application is not yet being offered as a "product" or "service" but I
invite you to check it out at http://www.spreadsheetmanagement.com/
I may be able to help you extract the information you need.

 

[Babs]

Hi Ron

I have run the RDB Merge Ad-in, to merge 95 Excel files. There is just 1
problem, it merged the files and data, but the fill colours of the cells are
now "no fill" and that is the most important part of my merge! How do I do
the merge and make sure that the cell fill colours are also duplicated?

Thanks
Babs

 

[Faisal Ijaz]

Dear Bernie,
Great work.
Please help me that how to save this macro, Do I have to paste again and
again..