workbook help

[Porknar]

Not sure if this is possible but here goes.

I have a sheet I am using to track shipment of parts. After I complete a shipment I would like to remove the row and put it into another sheet(Jobs Shipped). I am not sure how to post my workbook to the board.





Shipping Numbers Date Posted: 2006
8/3/2006
Job # PART# PO# TF# Qty Due Date Qty Shipped Balance Due Jul Aug Sep Oct Nov Dec
24422 HP125 po1 tf1 6 8/18/2006 0 6
21068 P300 po2 tf2 15 7/7/2006 0 15
24296 P300 po3 tf3 15 7/28/2006 0 15
21420 P300 po4 tf4 15 8/4/2006 0 15
13548 HP165 po5 tf5 15 10/2/2006 0 15
18544 Conn Rods po6 tf6 15 10/30/2006 0 15
14387 conn rod po7 tf7 20 8/4/2006 0 20
20617 Conn Rods po8 tf8 50 8/31/2006 0 50
18114 T100 po9 tf9 15 9/15/2006 0 15
17893 (BANJO) po10 tf10 5 9/20/2006 0 5
20801 Housing po11 tf11 9 9/22/2006 0 9
16957 Housing po12 tf12 11 8/31/2006 0 11
14883 Housing po13 tf13 21 8/11/2006 0 21
20597 250T po14 tf14 5 8/11/2006 0 5
24519 Conn Rod po15 tf15 57 10/16/2006 0 57
14713 200T po16 tf16 15 8/10/2006 0 15
13644 200T po17 tf17 15 8/18/2006 0 15
14810 200T po18 tf18 20 8/31/2006 0 20
24702 200T po19 tf19 16 8/31/2006 0 16\




Any help is greatly appericated.
Darrell

 

[Porknar]

New problem

Now when I change Sheet2 to Jobs Shipped and push the play button, it deletes everything except row 1. It pastes something on new sheet but does not look right. I will email you the workbook

Thank you so much for your help.

Darrell