Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to put records of same person on same row and delete duplica
Hello,
I have a worksheet that contains employee SSN on column A but on column D contains their Name and DOB. Example: Col A Col C Col D 123456789 Name Steve Smith 123456789 DOB 5011970 999554444 Name Jon Smith 999554444 DOB 12151975 I would like to write a macro to find matching SSN in column A and then put the DOB in the same row (column E) as the employee name. I will rename column E DOB. Also, then I would like to delete the duplicate row (DOB row). Loop until end of column A. Thank you very much, -- Thank You! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to keep 15 specific records and delete 1000 other rows. | Excel Programming | |||
Macro to delete duplicate records | Excel Programming | |||
Sorting and delete records with macro | Excel Programming | |||
Delete records using excel Macro | Excel Programming | |||
Delete records using excel Macro | Excel Programming |