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