Hello, i have a roster with all of people in my organization, and i want to be able to delete people who are not in a particular department. i am running my report several times for different departments, and each department has a varying number of teams with in it, for example;
Department A
Unit 10035
Unit 10037
Unit 10081
Unit 11011
Unit 11843
Unit 12716
Department B
Unit 18801
Unit 19515
Unit 21286
The department that i want to keep is on the Map tab, with thier individual ID in column D. for each department, i am restoring the full roster to the tab before removing the units which are not included on the current list, becasue at the end i am generating a file for each department.
The roster tab with the matching unti ID is in column G. How can i quickly loop through each row on Roster and keep only those which have a coresponding unit on my map tab?
Department A
Unit 10035
Unit 10037
Unit 10081
Unit 11011
Unit 11843
Unit 12716
Department B
Unit 18801
Unit 19515
Unit 21286
The department that i want to keep is on the Map tab, with thier individual ID in column D. for each department, i am restoring the full roster to the tab before removing the units which are not included on the current list, becasue at the end i am generating a file for each department.
The roster tab with the matching unti ID is in column G. How can i quickly loop through each row on Roster and keep only those which have a coresponding unit on my map tab?
