I have got Sheet called Team with some data like given below.
Name Team
---- -----
Marc Team1
Stacy Team2
walt Team1
Based on their names I want to to copy them to Team1 sheet and Team2 sheet.
ie IF name==marc copy him in to Team1 sheet
How do i do this using a macro
Name Team
---- -----
Marc Team1
Stacy Team2
walt Team1
Based on their names I want to to copy them to Team1 sheet and Team2 sheet.
ie IF name==marc copy him in to Team1 sheet
How do i do this using a macro