Applying Advanced Filter

[documike]

Thanks so much to those who have responded to my earlier questions. It's
solved most of the issues I couldn't figure out, so I'm nearly finished I
hope.

How can I run the Advanced Filter without manually doing it? I guess I
could try recording a macro. I will be always filtering the same data set
i.e. A9:N31 and using the Copy option to place the results in another
location. I was trying to avoid copying to another place on the sheet and
then using a macro to copy the data to another sheet but ran into the
following issue. I noticed if I set the filter in a cell on another sheet
and copy the results to the sheet, it deletes some of the existing data in
the cells below the area I want to copy to. Can't you limit the range of
cells that get affected? I don't understand why it's affecting cells out of
the area I'm trying to copy to.

 

[Tom Ogilvy]

Recording a macro would be easiest.

If there is enough room for the copied data, then it should not affect other
cells. If there is too much data (there is not enough room), then it will.

copying a filtered range, by default, only copies the filtered rows.
Perhaps you are copying more than the filtered range.