Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How print pages without including the first sheet? | New Users to Excel | |||
use sumif with criteria including sheet name | Excel Worksheet Functions | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
Open saved projects automatically? | Excel Discussion (Misc queries) |