I am working on a large spreadsheet (28,000 rows), I need to filter the data
then cut and past the relevent cells into a new column. But always I need the
data to remin in the same rows.
When I do, I filter by a relevent data range, I select the data I need to
move, press ctrlX, then select the top cell I need to move the data into and
press ctrlV.
Sometimes the cut, filtered, data is pasted into the filtered cells as I
would expect (this is what I want to do).
BUT sometimes the data is pasted into sequentual cells, from the cell i've
clicked downward. This results in over writting the wrong cells. This is a
majour headach and has already cost me a whole days work!

I think there must be some rule posible regarding the number of cells
selected? or the number of rows filterd?

Any help would be greatly appreciated