A
Annabelle
BACKGROUND
I'm setting up a project log comprised of hundreds of entries. One of
the columns (col. F) indicates status: Review, Active, Closed, Denied.
QUESTION
The first worksheet will be the historical list - all projects ever
requested. Based on the STATUS (col. F), I want all Review projects
automatically entered on the second worksheet, all Active projects
automatically enter on the third worksheet, etc. The goal is to limit
data entry to the master worksheet.
DETAILS
There are thirteen columns:
A. ProjNum B. Name C. System D. ValueType E. ValueAmt F. Status G. Size
H. Complexity I. Requestor J. RcvdDate K. StartDate L. EndDate M. Notes
Is there a formula I can use to accomplish this?
I'm setting up a project log comprised of hundreds of entries. One of
the columns (col. F) indicates status: Review, Active, Closed, Denied.
QUESTION
The first worksheet will be the historical list - all projects ever
requested. Based on the STATUS (col. F), I want all Review projects
automatically entered on the second worksheet, all Active projects
automatically enter on the third worksheet, etc. The goal is to limit
data entry to the master worksheet.
DETAILS
There are thirteen columns:
A. ProjNum B. Name C. System D. ValueType E. ValueAmt F. Status G. Size
H. Complexity I. Requestor J. RcvdDate K. StartDate L. EndDate M. Notes
Is there a formula I can use to accomplish this?