Help with macro

R

richzip

I would like to know if a macro can be set up to perform the following: I
have a large workbook with data for several employees, and each employee
number (column A) has at least 1 line for every date of the month.

If any of the rows for each employee has a certain value (RSV) in column C,
I would like to copy that value over to column D. For example: employee 123
has the code RSV in column C for one of his rows, so I would like to copy all
values in column C (for that employee), to the corresponding row in column D.
Employee 456 does not have the code RSV for any rows, so column D for that
employee is left alone.

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


Result:
A B C D
123 1/1 OFF OFF
123 1/2 OFF OFF
123 1/3 RSV RSV
456 1/1 xxxx xxxx
456 1/2 OFF OFF
 

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 1
Macro code question 1
Macro question 0
Is this macro possible? 3
macro question 0
Macro questoins 2
Macro question 2
Adding sequence numbers to paragraphs 0

Top