Summary sheet including only open projects.
 

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!
--
KTB

Summary sheet including only open projects.
 

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.

--
Best Regards,

Luke M
"KTB" wrote in message
...
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!
--
KTB