Combining multiple workbooks

R

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
 
T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top