Summary sheet including only open projects.
in [General]
|
From: KTB on 25 Mar 2010 10:06 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
From: Luke M on 25 Mar 2010 10:15 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" <KTB(a)discussions.microsoft.com> wrote in message news:990ECBD2-888C-4D8C-8A5F-5E4B3EDFE4D8(a)microsoft.com... > 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
|
Pages: 1 Prev: Why am I getting this VBA error? Next: plz solve this i need solution |