Evaluate worksheet, copy cell to new worksheet based on condition

asked 2017-04-21 14:56:39 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.

edit retag flag offensive close merge delete

Comments

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.

Lupp gravatar imageLupp ( 2017-04-21 15:49:09 +0200 )edit

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.

Regina gravatar imageRegina ( 2017-04-21 18:58:09 +0200 )edit

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

rautamiekka gravatar imagerautamiekka ( 2017-04-21 19:21:03 +0200 )edit