I have a master table and if one of the columns has a "No" in it then I would
like the information in that row to automatically be copied into another
table with the same heading information. Very similar to using a filter, but
actually copying the information.
For example...i have this table


Name RSVP Date Received
Jane Doe Yes 1/30/2008
John Doe No
Jill Doe Yes 2/5/2008
Jack Doe No

And I want it to automatically put it in something like this on a different
worksheet:

Name RSVP Date Received
John Doe No
Jack Doe No


Thanks in advance for the help!