I have values in a column:
Column A
4 row 1
5 row 2
6 row 3
7 row 4
I do a filter on this column and I select only 4 and 6
Then I go to select visible cells and select two non-adjacent cells
make a copy
and then go to a different column and select the first cell
and then I pasted values.
Value 4 and 6 are pasted, but they are not pasted on the correct rows.
4 is pasted in row 1
6 is pasted in row 2 (while it should have pasted on row 3)
How can I take care of this?
Regards,
GN0001
Column A
4 row 1
5 row 2
6 row 3
7 row 4
I do a filter on this column and I select only 4 and 6
Then I go to select visible cells and select two non-adjacent cells
make a copy
and then go to a different column and select the first cell
and then I pasted values.
Value 4 and 6 are pasted, but they are not pasted on the correct rows.
4 is pasted in row 1
6 is pasted in row 2 (while it should have pasted on row 3)
How can I take care of this?
Regards,
GN0001
