Autofilter Autoupdate
 

I have a spreadsheet that needs to gather information from one worksheet
based on certain criteria and feeds it to another. I have tried setting it
up so that if one row of data has an X in the end column then that row of
information is copied over to the new worksheet. I run into empty blocks
when I do this, however.

I next tried to have all the information duplicated by cell reference over
to the new sheet and apply a filter so that only the X rows shows. While
this works, I want to be able to hide the column that's being filtered from
the user. Also, as more rows are added to the source worksheet, they are not
be automatically updated to the applied filter.

If this is something Excel can do, what solution makes sense? Can I create
perhaps a command button and entitle it "Update" for the users to press which
will refilter for new results?
--
Lori