I would like to be able to perform the following. When particular
data is entered into one column and then any data entered in another
column then the second data entered would then appear in another
column on another sheet in the workbook. Example: column b entered
data is normally the word OK. If the OK was changed to NG and then a
comment was entered into column c then the comment entered into column
c would appear in another column that is located on a separate sheet
in the workbook and a different column. Thanking you in advance for
your help.
Sam

If you use the Worksheet_Change event to trigger the copy and paste action,
then it could be triggered from either column B being changed from OK to Ng
or by the comment in column C being changed. You did not specify whether the
comment would be preexisting or would be entered after the change in column
B. This method causes the change to take immediate effect. However, if
there are a lot of changes being made, the user will have to wait each time
until the program runs to do the next item. If the worksheet is not too
large, that should not be a problem.

Another approach would be to search column B for all the cells not equal to
OK and then perform the copy and paste. This could be done in one fell swoop
and the user could run the macro at their discretion.

Think about it.

"Sam" wrote:

I would like to be able to perform the following. When particular
data is entered into one column and then any data entered in another
column then the second data entered would then appear in another
column on another sheet in the workbook. Example: column b entered
data is normally the word OK. If the OK was changed to NG and then a
comment was entered into column c then the comment entered into column
c would appear in another column that is located on a separate sheet
in the workbook and a different column. Thanking you in advance for
your help.
Sam