Combining multiple workbooks

[Roger Dodger]

Hi All,

My work platform only allows for 16 searches per file so have to process 2,3
or 4 searches and save them to CSV.

We will call them Nit1, Nit2, Nit3 and Nit4.

I need to combine all the CSV file data without the extra Column headings
so that I get one sheet with one lot of headings and the rest of the data
from Nit1, Nit2, Nit3 and Nit4 below.

One more thing, the length of data in each file can change due to days per
month and the times a particular chemical was used.

Surely Excel can do this somewhere?

Any help will be appreciated

 

[trip_to_tokyo]

Hi All,

My work platform only allows for 16 searches per file so have to process 2,3
or 4 searches and save them to CSV.

We will call them Nit1, Nit2, Nit3 and Nit4.

I need to combine all the CSV file data without the extra Column headings
so that I get one sheet with one lot of headings and the rest of the data
from Nit1, Nit2, Nit3 and Nit4 below.

One more thing, the length of data in each file can change due to days per
month and the times a particular chemical was used.

Surely Excel can do this somewhere?

Any help will be appreciated

In EXCEL 2007 there is a Help Topic called:-

Consolidate data in multiple worksheets

Do a search on the above to find it.

It's explains how the topic can be done in EXCEL but I think it's not
quite what you want.