Sample Workbook.xlsxI need a VBA that can delete redundancies and transfer the second score (if there is one) over to another column. Here is an example.
Before_Macro
Name___________ID_____Loc____Score
Mark_B.________1223___NY_____3
Mark_B.________1223___NY_____2
Anthony_M._____3200___LA_____1
Anthony_M._____3200___LA_____4
Ben_A._________1101___HO_____2
Ben_A._________1101___HO_____3
Elizabeth_S.___2600___NY_____2
Christina_G.___4206___LA_____3
Christina_G.___4206___LA_____6
Daniel_F.______9880___NY_____3
After_Macro
Name___________ID_____Loc____Score_1___Score_2
Mark_B.________1223___NY_____3_________2
Anthony_M._____3200___LA_____1_________4
Ben_A._________1101___HO_____2_________3
Elizabeth_S.___2600___NY_____2___
Christina_G.___4206___LA_____3_________6
Daniel_F.______9880___NY_____3
Please help!
Bookmarks