If - Then - Now what?

[Tamara]

I have a worksheet that contains a very long list of specific data. I want
to create a column in that worksheet that users will be able to change the
status to "Active". Once status in worksheet is changed to "Active", I then
want the "Active" records to be visible on the worksheet called "ACTIVE".
The worksheet that houses the original data is called "Prospects".

i.e. User goes into workbook and inputs the word Active in the "ABC
Company" record (Column A - "Status") from "Prospects" worksheet, saves, and
closes. Without user doing anything, worksheet named "ACTIVE" has pulled all
information from "Prospects" and displays it on the "ACTIVE" worksheet. Any
notes added to the record on the "ACTIVE" worksheet automatically transfers
to "Prospects".

I tried to find something in help and it didn't work. Any help is
appreciated.

 

[RobN]

Tamara,

Why don't you just filter the column that has the word Active to show only
the rows that have Active shown in that column?

Otherwise you could,
1. use the Advanced Filter method to copy the Active rows to the Active
sheet.
2. use the VLookup function from the Active sheet in such a way that only
the data with those showing Active appear.
3. various other ways not mentioned here.

You may want to decide on the method that suits and if you're having
trouble, further help could be provided.

Rob