Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining multiple workbooks
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining multiple workbooks
On Aug 19, 5:18*pm, "Roger Dodger" wrote:
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining data from multiple workbooks | Excel Worksheet Functions | |||
Combining data from multiple workbooks | Excel Worksheet Functions | |||
Combining Multiple Workbooks | Excel Discussion (Misc queries) | |||
Combining Multiple Workbooks | Excel Discussion (Misc queries) | |||
Combining Data from multiple workbooks | Excel Discussion (Misc queries) |