Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge & Sort Dynamic Lists w/ Data Validation retailmessiah Excel Discussion (Misc queries) 3 August 5th 08 04:20 PM
merge database or sort? anand Excel Worksheet Functions 5 June 16th 07 07:28 AM
Sort and/or merge to worksheets. mikri Excel Worksheet Functions 3 February 26th 07 03:38 PM
Merge and sort two pages RD Wirr Excel Worksheet Functions 3 January 13th 06 01:34 AM
Merge and sort pages of data RD Wirr Excel Worksheet Functions 2 December 21st 05 06:38 AM


All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"