Copy Filtered column in Full

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top