Windows XP Copying data onto a new sheet depending on selection from list

S

struggling_with_excel

Joined
May 5, 2009
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fill combobox depending on selection from another combobox 2
Jump to a different cell depending on list selection 3
DATA IN SHEET 1 ON THE BASE OF SHEET 2 1
Moved data to new sheet based on list selection 1
Pulling Specific Rows from a Table onto a New Sheet 1
Creating a dropdown list based on selection from a differernt drop 5
Filling a List Box in Excel from an Array 4
Selection from list on main sheet from suplemental sheet in same w 1

Top