R
richzip
I have a large worksheet with about 700 employees; each employee has at least
1 row for every date of the month, and several columns. For each employee, I
would like to search Column C for one of 2 specific values. If Column C, in
any row for for that employees equals one of those values, then ALL values in
column C for that employee should be copied to the corresponding row in
Column D. If neither of those values are found in column C, then column D
for that employee is left alone.
Example is on the first reply to this topic.
1 row for every date of the month, and several columns. For each employee, I
would like to search Column C for one of 2 specific values. If Column C, in
any row for for that employees equals one of those values, then ALL values in
column C for that employee should be copied to the corresponding row in
Column D. If neither of those values are found in column C, then column D
for that employee is left alone.
Example is on the first reply to this topic.