Copy Paste all data tough filtered

G

Guest

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
 
D

Dave Peterson

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.
 
G

Guest

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

BR
MakeLei
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy visible cells after filtered paste to first empty cell 1
loop to copy paste 5
Copy Range of data using VBA 0
Copy columns and paste with blank column between 5
sort macro not working 1
copy/paste in the next column 4
Extract filtered data 1
Filter and copy data to other sheet 3

Top