Wanting to sort

Guys I am wondering if you can help me out on a little project that I have going on right now. My question to you is this. I have a spreadsheet that I have attached. What I want to be able to do is have the Department column (Column C) be a drop down where I can select a department and then have excel displace only that information relavant to the department that I have selected. Bear in mind I am using excel 2002...i know kinda old...but that is what I am working with. Is this possible.

I think that what you want to be done is possible, except I'm not exactly sure what you want to happen. Could you please clarify?

I want the 'c' column (department ) to have a listing of various departments. Ie. REO, Valuation, accounting so on and so forth. I want to be able to click on that drop down and select on a department. Then I want excel to show only information about that department. I do not want to see information about reo or accounting if i selected the valuation from the drop down. I hope this makes things alittle be clearer....