Create Excell table from contects of another
 

I have an existing table with multiple entries (say 200). each has a status
code "1" or "2". how do I code a function (or something) that will allow the
second table to automaticaly populate its entries from the first table and
contain only the records (say 15) with a status code of "1". Where 2nd table
will now only be 15 rows long with no blank rows in between. Using Excel 2003