Autofilter on not equal to 0

F5Special to select visible rows.

Copy and paste to Sheet3 at B23

Go back to source sheet which still has visible cells selected and
DeleteEntire Row.


Gord Dibben MS Excel MVP




On Thu, 1 Oct 2009 08:00:02 -0700, Withnails
wrote:

Hello
I am looking for a way to grab data in sheet1 column Y that is 0 or <0 (ie
any number that isnt 0). I then want to take those rows where data is
located, cut and paste them into Sheet3, starting at B23.
Does anyone know a good way of doing this? Thank you