There are many threads on this Forum dealing with merging tables, worksheets,
and workbooks, but I cannot locate one that suits the problem I am trying to
resolve.

Problem:
I have two worksheets of data.
The 1st (WS1) contains the following 5 headings (columns):
Date | Econ | Dist | Cost per | Total $

The 2nd (WS2) contains 3 columns:
Date | Total $ | Service Type

Both worksheets contain many rows of data that are constantly being added to
- via a data connection to 2 CSV text files. Both text files are sorted in
Date order (newest to oldest). Many of the Dates contain data in both text
files.


Result Desired:
I want to dynamically merge the two sets of data into a 3rd worksheet (WS3),
with the following 6 headings (columns):
Date | Econ | Dist | Cost per | Total $ | Service Type
and sorted into oldest to newest Date order.
Multiple entries for each Date are allowed.

BTW I am using Excel 2007.

The data constantly added to so I am looking for a method that will update
the merged table instantly and dynamically. Can anyone help me code a
formula (or series of formulas) to do this, please? By reading other similar
threads in this Forum, I am guessing there will need to be a combination if
IF, INDEX, ROW / COLUMN, INDEX, MATCH, OFFSET etc formula to make this work.
Whilst I consider myself resonably proficient with Excel, most of those
formula leave me cold.

Any help will be certainly appreciated.

--
Regards,
Dave C.

Brisbane, Australia