Hide Rows if a task is complete

Hello all,

I've got a bit of a problem and hope I can find an answer here:

I've got this excel spreadsheet that I did up. It has many rows of items and about 6 columns of information. The last cell is a "complete" cell.

What I want to do is make it so that the rows that get changed to "complete" disappear or get hidden from the excel spreadhseet.

is there a way to do this?

Reason I want it done:

I want to be able to enter tasks and once they are complete, have them disappear from the screen leaving only the active tasks visible.

Ok, so I have this spreadsheet (attached) with information on it.

What I want to do is to be able to fill out the COMPLETE cells with an 'X' in it and have that entire row that the 'X' corresponds to become invisible (disappear?).

Is this possible?

I'm using Excel 2003 at work (2010 at home), how do I get to the code screen in 2003?

I got it, and yes, sir. that works! Thank You!

Now, the big question: How do I bring the data back out if I need to review all the items that have been completed to date?

Again, I found the info. I really have to stop and think before I post, hahaha. A little confidence in my own skills is what I need!

Here's a follow up question regarding the macro you provided, ChemistB ...

Is there a way to activate this macro and have the columns hide AFTER the data has already been inputted?