Find and copy to different sheet

[bazwillrun]

Hi wonder if anybody would be able to help me out please

Column A, Sheet 1, find any number greater than 0

and copy to Column A, Sheet 2

Many thanks

[nimbus3000]

Please Login or Register  to view this content.

[bazwillrun]

apologies if this post appears twice but am having some B/band issues this morning.

Hi thanks for your quick reply, unfortunately I cant get it to work.

i have opened a new workbook to test it, Sheet 1, Column A, i entered some numbers with a few zeros, copied your script and ran it but nothing was copied over.
Any ideas
Thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[bazwillrun]

That works
Many thanks

[JOHN H. DAVIS]

You're welcome. Glad to help out, and thanks for the feedback.