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

Tim & Holly
Yes, Excel can do that but what you say is not clear on what column you
would be entering the "X". Is it always the same column? Or is it one of
several columns? If so, what columns? You say "If I put an "X" or other
value in...". says that any value in a cell and you want the action to
occur. I don't think you mean that. If you wish, send me your file or a
small file with several examples of what you have. Clearly state the range
(of columns or rows) in which you want Excel to watch out for an "X". If
you can't nail down the range, just explain it. If you want Excel to also
watch for values other than an "X", state those other values.
You say that you want the whole row copied to another sheet. Clearly
state where in this other sheet you want the data pasted. In the first
empty row maybe?My email address is . Remove the "nop"
from this address. HTH Otto
"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

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