Macro question

R

richzip

I would like to know if a macro can accomplish the following: I have a large
worksheet with about 600 employees, and each employee has at least 1 row for
each date of the month.

For each employee, I would like to search in Column C for one of 2 different
values (RSV, NEW). If that value is found in ANY row for that employee, it
will copy all values in column C (for that employee) to the corresponding row
in column D.

Example: Employee 123 below does have RSV in at least one of his rows. So,
all values in columns C are copied to the corresponding row in D.
Employee 456 does not have RSV or NEW in any of his rows, so all of column D
is left alone for that employee

Original:
A B C D
123 1/1 OFF aaaa
123 1/2 OFF OFF
123 1/3 RSV bbbb
123 1/4 cccc
456 1/1 aaaaa aaaa
456 1/2 bbbb bbbb

Result
A B C D
123 1/1 OFF OFF
123 1/2 OFF OFF
123 1/3 RSV RSV
123 1/4
456 1/1 aaaaa aaaa
456 1/2 bbbb bbbb
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro question 0
Is this macro possible? 3
Macro question 1
Macro code question 1
Help with macro 0
Macro questoins 2
Macro question 2
Filling in some blanks to a data table 3

Top