Copy Filtered column in Full

G

Guest

I have filtered a worksheet and have been copying data from one column into
another, however the worksheet has now reverted to only allow me to copy
sequential rows, so I can only copy and paste a few cells at a time. Can you
advise how I can go back to being able to copy and paste the full column?
 
G

Guest

Hi,

I will recommend that you use Advanced Filter technique. That's because if
you make any mistake while entering data, your spelling mistake can be taken
care of in the Advanced Filter. For exampe, if you enter a mispelled data in
the field then you must have to filter more than once to get the exact number
of matching records.

Challa Prabhu
 

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

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Filter - Copy info 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Filter Sort Columns in a table. 3
copy and paste filtered cells 1
Data Filter on Selected rows and columns 2
How do I Copy and Paste onto Same Rows after filtering out rows. 2
Filter, Copy and Paste 2

Top