S
scasawyer
I think this should be easy but can't seem to get it right
Example
A B
C D E
Column of ID Number
(Number to be entered) Name Current Date
NO 1001
1002
1003
1004
Now what I need is to be able to put number in to cell in first column and
have it place the current date in cell in column C and have the NO in column
D changed to a Yes but only if the number exist in Column I.
Thanks for any help
Example
A B
C D E
Column of ID Number
(Number to be entered) Name Current Date
NO 1001
1002
1003
1004
Now what I need is to be able to put number in to cell in first column and
have it place the current date in cell in column C and have the NO in column
D changed to a Yes but only if the number exist in Column I.
Thanks for any help