Merge and Order Data From Two Sheets

Hi,

I am looking for a little help with merging and sorting some data.

Currently I have two sheets linked to SQL databases. They are pulling through sales order information, one has the header info (variable number of lines due to version), one has the line info (variable number of lines per order); unfortunately they are in separate tables and so cannot be pulled through together.

My ideal scenario is to do the following:

On the actual data sheets, to the right of the data I will copy the relevant information I need from the mass data (using =). So on both sheets I will end up with the same number of columns, with the same column headings.

Then what I would like is to take the data from both sets and combine them into one dataset on a third sheet, which also sorts them by the order number (each order has its own unique number). So I will then end up with the header of the order followed by the lines of the order.

It would be even better if it could auto-group the lines with the single line from the header (the latest version (there is a version column with ascending number series)) every hour, so the third data sheet would need to reflect any changes.

Is any of this possible, and if so I would really appreciate any help in doing this. I am using Excel 2010.

Many thanks

Matt

Please upload sample files so your request is clear.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.