I am looking to generate a table of names (ClassRoster) on a worksheet generated from a master worksheet (Applicants) based on a condition.
If the cell starting starting at 2 to the last cell in column C on the Applicants worksheet equals ‘2’ then copy the text in the Applicants worksheet column I starting at cell two and paste it in column A on worksheet ClassRoster.
The goal, if an applicant has been selected, column C set to ‘2’, to attend class – their name is copied to the ClassRoster worksheet thus building a list of names. I would like to accomplish this with no blank cells between names.
Any help is appreciated.