place this macro under <worksheet_change event under the particualr sheet.
right click the particular sheet and clcik view code and then on the
rightside window click the arrow and choose <workshee_change and there
palce the macro.


"Tim & Holly" wrote in message
om...
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