Copy and Paste filtered data

[vjharry]

I have copied Row no. 2,4,6 fro this GREEN table and want to paste same date in J and K column (in same row numbers)then how can I do this ?

It should Show like this if I
1 First I filter only Yellow cells
2 then I copy that Filtered cells
3 after that copying that filter cells I did Paste in same rows in J and K column

Hope I get positve reply..


thanks in advance

[FDibbins]

When you filter data, and then copy the visible rows, excel treats that copied range as if thats all there was. So when you paste, it is as if the non-visible rows did not exist.

When you filter and all that shows is rows 2, 4, 6, when you copy/paste that, it will get pasted as 2, 3, 4.

What exactly are you trying to do?

edit: ok after opening your file (should have done that 1st), I see that you are pasting the data to the right of the filtered range. then when you unfilter, you have empty spaces. This will not happen if you copy below the filtered data

[vjharry]

it will get pasted as 2, 3, 4.

What exactly are you trying to do?

I want to get it pasted in 2, 4, 6th row only .. !!

and after removing that filtered data it should show like M & N column.

[FDibbins]

I added to my post, did you see the edit?

[vjharry]

ok seen now...

[FDibbins]

so...do you ant the gap between the pasted cells or not? And what determines what gets filtered?