software

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 quot;Xquot; or other value in . If the certain column is populated
with a value of quot;Xquot; 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 quot;Xquot;. Can I automatically copy the
whole row of infomation to another worksheet?

Any help would be appreciated.
Thanks,
Tim
place this macro under lt;worksheet_changegt; 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 lt;workshee_changegt; and there
palce the macro.quot;Tim amp; Hollyquot; gt; wrote in message om...
gt;I am looking to copy a row of inforamtion to another sheet automatically
gt;based upon a cell in which I set a value in.
gt; The example being:
gt;
gt; I have a certain part number that has a certain number of operations that
gt; need to be done to the part. I would have a series of coulmns in which I
gt; would put an quot;Xquot; or other value in . If the certain column is populated
gt; with a value of quot;Xquot; or other value. I would like to automatically coipy
gt; that row of inforamation to another worksheet in a area under the
gt; workcenter in whcih it need to be run.
gt;
gt; Ex.
gt; A B C D E
gt; Part Number Part Name 3 Axis Lathe Qty. Due Date
gt; 57932 Poppet X 2,150
gt; 3/14/2006
gt;
gt; Since I populated the Column C2 with an quot;Xquot;. Can I automatically copy the
gt; whole row of infomation to another worksheet?
gt;
gt; Any help would be appreciated.
gt; Thanks,
gt; Tim
gt;
Tim amp; Holly
Yes, Excel can do that but what you say is not clear on what column you
would be entering the quot;Xquot;. Is it always the same column? Or is it one of
several columns? If so, what columns? You say quot;If I put an quot;Xquot; or other
value in...quot;. 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 quot;Xquot;. If
you can't nail down the range, just explain it. If you want Excel to also
watch for values other than an quot;Xquot;, 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 quot;nopquot;
from this address. HTH Otto
quot;Tim amp; Hollyquot; gt; wrote in message om...
gt;I am looking to copy a row of inforamtion to another sheet automatically
gt;based upon a cell in which I set a value in.
gt; The example being:
gt;
gt; I have a certain part number that has a certain number of operations that
gt; need to be done to the part. I would have a series of coulmns in which I
gt; would put an quot;Xquot; or other value in . If the certain column is populated
gt; with a value of quot;Xquot; or other value. I would like to automatically coipy
gt; that row of inforamation to another worksheet in a area under the
gt; workcenter in whcih it need to be run.
gt;
gt; Ex.
gt; A B C D E
gt; Part Number Part Name 3 Axis Lathe Qty. Due Date
gt; 57932 Poppet X 2,150
gt; 3/14/2006
gt;
gt; Since I populated the Column C2 with an quot;Xquot;. Can I automatically copy the
gt; whole row of infomation to another worksheet?
gt;
gt; Any help would be appreciated.
gt; Thanks,
gt; Tim
gt;