Macro to extract account numbers

I have account numbers in Col A and Values in Col B on sheet "Acc Numbers"

I have tried to write code to extract the account numbers from sheet "Acc Numbers" to sheet "Extract Acc Non Zero"


I need the code amended to only extract the account numbers where the value in Col B is not zero

Please Login or Register  to view this content.

Your assistance is most appreciated

Try

Please Login or Register  to view this content.

Thanks for the help Jindon