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!