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

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

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
>

Maybe you could copy the sheet
Unfilter the range on that copied sheet
Copy the data
paste the data
delete the sheet

I don't know if it would be quicker, though.

Makelei wrote:
>
> 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
> >

--

Dave Peterson