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.
--
Regards,
Tom Ogilvy
"documike" <(E-Mail Removed)> wrote in message
news:0jmBd.832728$8_6.391585@attbi_s04...
> 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.
>
>
>
|
Similar Threads
