I am looking for VBA code to look in the “master” sheet and find all the “A”
s in a column.

Once it finds an “A”. It copies the row and paste it into another sheet
“NPS”.

Go back to master delete that row and move on to the next

Repeating until the column is exhausted of all the A’s. Column is always Q.


I tried this with an autofilter and messed up on the delete phase.

New to complex macros and any help would be appreciated.

--
Message posted via http://www.officekb.com