Thanks Dave,
I have to copy row by row and then I am able to include also filtered cells.

BR
MakeLei

"Dave Peterson" wrote:

It may depend on the version.

xl95 will copy all the cells (visible and hidden)
xl97-xl2003 you have to show the cells. Excel will not copy those hidden cells.
xl2007 (I think...) If you select cells inside AND outside the autofilter
range, then the hidden cells will be copied--at least that what it sounds like
from reading posts from people who complain about this feature.



Makelei wrote:

Hi,
How can I copy all data in cells even when autofilter is ON and some values
have been selected. I need to let users to filter data, but I need to copy
all data from one column in Sheet1 to another column in Sheet2?

I have tried to copy paste, but it will copy only the visible data, but I
need to get also the data that is hidden.

BR
MakeLei

--

Dave Peterson