pasting with filter results into sequentual cells not same row?
 

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

pasting with filter results into sequentual cells not same row?
 

Hi,

I'm not aware of any method of copying which will only copy the selected
cells but skip interviening cells that contain data and then paste items on
the corresponding rows leaving the interviening rows empty. There is a
command Paste Special, Skip Blanks but that only works if the copied cells
are blank. And if you copy a filtered range Excel copies only the visible
cells and always pastes them adjacent to each other never skipping rows for
uncopied items?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"nick" wrote:

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