[struggling_with_excel]

Hi

I am quite basic with my skills in excel and after many frustrating attempts I cant figure out this problem...

I have a spreadsheet which contains information relating to patients having surgery, such as their name, hospital number etc (in cells E - P) and a drop down box with two options - completed or cancelled (cell C) - which is filled in the following day depending on if the case went ahead.

What I am trying to do is set up a sheet which will list all the patients when "completed" is selected and another list when "cancelled" is selected to allow tracking of patients.

Could anyone please advise me on how to do this as I am going insane :S