Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge and Sort 2 Worksheets
I have two worksheets of data.
The 1st (Fuel) contains the following headings: Date | Econ | Dist | Cost per | Total $ The 2nd (Service) contains: Date | Total $ | Service Type Both contain many rows of data that are constantly being added to - via a data connection to 2 CSV text files. The text files are sorted in date order (newest to oldest). I want to merge the two sets of data into a 3rd worksheet, with the following headings: Date | Econ | Dist | Cost per | Total $ | Service Type and sorted into Odest to Newset date order. I am using Excel 2007. Any help will be certainly appreciated. -- Brisbane, Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge & Sort Dynamic Lists w/ Data Validation | Excel Discussion (Misc queries) | |||
merge database or sort? | Excel Worksheet Functions | |||
Sort and/or merge to worksheets. | Excel Worksheet Functions | |||
Merge and sort two pages | Excel Worksheet Functions | |||
Merge and sort pages of data | Excel Worksheet Functions |