I have a database that is three columns. I want to use this first sheet as
an entry sheet and create two additional sheets that automatically fill in as
I add data to Sheet 1. The second sheet should only show those with an award
year, and the third sheet should show only those WITHOUT an award year. Is
it possible to make these all automatic? I know that it would be easy to
filter this, but my boss doesnt' want to have to do anything to see the data.
Thanks for your help.

Award Year Last Name First Name
Anstett Hope and Joseph
Artzt Ed
1993 Autzen Tom
Ballmer Connie and Steve
Barton Michael and Mary Ann
1994 Bowerman William and Barbara
Brown Richard Louis
Cameron Gerry and Marilyn
1991 Chambers Carolyn Silva
1998 Chiles Earle M.
2004 DeArmond Robert and Leona
Engemann Roger and Michele