Bad title description so I'll explain.

Sheet 1 in column A I have NAMES and in column B I have STATUS. Names are people (Smith, Jones etc) and there are three status options (On caseload, Discharge, Transfer).

On sheet 2 I'd like column A to be the names of those people with the status "On caseload" with no row gaps. Eg.

Sheet 1
COLUMN A COLUMN B
1|SMITH on caseload
2|JONES discharge
3|RICHARDS on caseload

Sheet 2
COLUMN A
1|SMITH
2|RICHARDS

At the moment I can use IF to achieve this but this produces gaps in the rows. Any ideas? This is clearly beyond me.

Thanks.