Go here and look for data validation examples and explanations.
http://www.contextures.com/tiptech.html


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"David L." wrote in message
...
I have a very basic table/database (columns of data with a field name in
the
first row) on a sheet in one tab. How can I have other tabs which
dynamically show only data that matches certain criteria in the database?

For example, my database has columns for the Project Name, Project Number
and Status. In the Status column, it shows either Active, Closed or Dead.
How can I construct the worksheet so I have one tab that shows all of the
data for the Active projects, one for the Closed projects and one for the
Dead projects? I want the data on these 3 tabs to automatically change as
the original database sheet is added to and/or updated.

Any help is greatly appreciated.