Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
Macro Question | Excel Programming | |||
macro question | Excel Programming | |||
one more macro question | Excel Programming | |||
one last macro question | Excel Programming |