copy and paste in visible cell from filtered column in Excel 2007

Hello, everyone. I still use excel 2007. I have a problem with copy paste in visible cell from filtered colum. How about copy in visible cell from filtered column and paste it in visible cell from filtered column too. Thanks master

In a visible cell or in an invisible cell?

Ok, then what exactly is the problem? You want to copy data from a column that contains filtered values? Should be no problem there. You want to paste values in a filtered column? At the moment I don't see the point, but perhaps un-filter the column, paste, then filter again?

Originally Posted by bmouse

Ok, then what exactly is the problem? You want to copy data from a column that contains filtered values? Should be no problem there. You want to paste values in a filtered column? At the moment I don't see the point, but perhaps un-filter the column, paste, then filter again?

yes I usually don't have a problem. But today I have problem. When I copy, it will copy visible and invisible cell and when I paste in filter cell, it will paste to invisible cell to. Here is the picture 2014-12-15_191845.jpg
first, I have filtered the column, then I wanna copy column to column b then, the result the same with the picture

Ah, now I get it. Well, this is just how filters work.
To get around it, you have to copy the data, paste it, remove the filter from the copy source column to see all the data you've pasted, then copy it again from the 2nd column and paste anywhere. Now you will have all the filtered data.

Originally Posted by bmouse

Ah, now I get it. Well, this is just how filters work.
To get around it, you have to copy the data, paste it, remove the filter from the copy source column to see all the data you've pasted, then copy it again from the 2nd column and paste anywhere. Now you will have all the filtered data.

any easier tips , master?

Depending on the amount of data you have to copy, you could:

1.apply the filter;
2.change the color of the filtered data;
3.remove the filter;
4.copy the data manually.

Originally Posted by bmouse

Depending on the amount of data you have to copy, you could:

1.apply the filter;
2.change the color of the filtered data;
3.remove the filter;
4.copy the data manually.

Okey sir, many thanks