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.