I am looking to copy a row of inforamtion to another sheet automatically
based upon a cell in which I set a value in.
The example being:

I have a certain part number that has a certain number of operations that
need to be done to the part. I would have a series of coulmns in which I
would put an "X" or other value in . If the certain column is populated
with a value of "X" or other value. I would like to automatically coipy that
row of inforamation to another worksheet in a area under the workcenter in
whcih it need to be run.

Ex.
A B C D
E
Part Number Part Name 3 Axis Lathe Qty. Due Date
57932 Poppet X 2,150 3/14/2006

Since I populated the Column C2 with an "X". Can I automatically copy the
whole row of infomation to another worksheet?

Any help would be appreciated.
Thanks,
Tim