Thread: Copy and Delete Data from One Sheet to another.

A flat file of all open orders is exported from our accounting system into excel file. This file has hundreds of lines. We then take this file and manually select the orders we want our warehouse to ship. I would like to select the orders to ship and have a code copy these lines to another workbook (Req. Shipments) that keeps track of all orders selected to ship that year. From this point I need another code that removes all lines from the open order file that match with an order number on the (Req. Shipments) Workbook. This way it will make it impossible to duplicate orders. (needed because some orders still show open in our accounting system because it has not invoiced yet.) Any Solutions. Please see attachment.

Example
When I select Orders to ship i fill in the Ship Qty in Column F I then delete all other lines that are not shipping. After running this for a week or so I should be able to run the VBA and be left with only Orders that need to still be sent to my warehouse for shipping.

This Would be a life saver. Sorry if its confusing. I don't know how to simplify what I'm saying.

I don't really understand what you are asking. Perhaps you could add an illustration of your expected results?

Sorry. Ok Basically I should have broken this down into 2 post.

1. I need to select lines I want to ship and delete all others. I need VBA that copies all remaining lines to another workbook(workbook 2). Workbook 2 would keep an ongoing list. So new data copied over would have to paste below existing data.

2. When I open up the Open order sheet I want to run a different code that would delete all lines that matched with lines in Workbook 2.