Summary sheet including only open projects.

[KTB]

Have a workbook with 2 worksheets. Main worksheet contains all projects,
opened, cancelled and closed. Contains columns A-Q. Column Q is entitled
"Complete". Valid entries in the column appear to be cancelled, yes or
blank.
They want the second worksheet to contain only current projects and only
columns A-M. As a project completes they want it to be deleted from the
current projects sheet.
I know there's a way to do this somehow but not very familiar with coding
VBA.
Thanks!

 

[Luke M]

Two possible ideas:

Record a macro of you clearing sheet 2, and then doing an Advanced Filter
from sheet 1 to sheet 2 with the project status as your criteria.
(http://www.contextures.com/xladvfilter01.html)

Or, have sheet 2 simply be a PivotTable that is filtered to only show
non-complete projects.