Transfer data from one table to another

[framie666]

Hi,

I'm not sure if what I need to do is simple or not, and if it it is any advice would be appreciated? Ive got a spreadsheet which details the date of an ordered item and the date we expect it to be delivered. I then want to store the status of the delivered goods in a separate table on another sheet. So basically I want to be able to track which goods we are waiting for and to be able to tell if they are ahead of schedule or overdue. On receipt of the goods I then want it to disappear from this table.

Any idea if this is a straight forward project and/or any suggestions?

Many thanks
Scott

[FDibbins]

perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
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.