L
Lee
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!
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!