I have a master project list where I list all the projects that I've had in the past. I add projects to this list as they come up.

I'd like to be able to have 2 other sheets (open/closed) where I can quickly find which projects are open. The way I know a project is closed is when there is a date in the "date closed" column.

I'm having trouble copying the entire row of information for that project into a new sheet when the date closed cell in that row is empty or has a date in it. The master list should contain the full list of projects (open+closed). Help?