If you paste a multiple row selection into an auto filtered selection, it
will paste as though the autofilter was not on, in other words the auto
filter may show rows 2,6 and 10
but if you paste a three row selection into row 2 it will paste into rows
2, 3 and 4.

"KLynn727" wrote:

I recently had a large dataset in excel that I needed to add select
information to. I used autofilter to locate the rows I needed and then
entered the new information by cutting and pasting from another workbook. I
later found that the columns did not match up anymore - as if the columns had
been sorted separately. I did not sort any of the columns separately so the
only thing I thought it could have been was my use of autofiltering, but I
thought this was not supposed to alter your dataset? Help - I don't want
this to happen again!

Thanks!