Evaluate worksheet, copy cell to new worksheet based on condition

[moseman]

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.

[Lupp]

May I understand this as:
I have a sheet with data in (at least) one column. A different column is dedicated to contain a selector occurring with either an accepting or a rejecting value.
A different range shall now be filled with the data associated with the accepting selector.
Please make also clear if you are looking for an interactive solution or have to insist on one by formulae.

[Regina]

Two suggestions: (1) Make you master sheet a database table and generate the derived sheet by a Query. (2) Define a filter on the master data and let the filter result be written to the other sheet.

[rautamiekka]

A wiki question asking for help with Excel … Sound odd ?