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?