Finding values greater than zero and copying to another sheet

Please Login or Register  to view this content.

I have got help on this code from a fellow user. In the file I have attached, this code works great taking information that has a value greater than zero from Sheet2 and putting it onto Sheet3. I tried to use this code to take information from Sheet1 from different cells than Sheet2 and also put it onto Sheet3, but I can not get the code to do anything. If anyone is familiar with this code, could you please explain what each line is doing. I can not seem to understand how it is working.

Thank you

Example.xlsm

[QUOTE=pasqualebaldi;3694959]

Please Login or Register  to view this content.

I had forgot to changed "Sheet2" to "Sheet1", but the problem still exists.

Originally Posted by stnkynts

Here is how I would approach it

Please Login or Register  to view this content.

I think I can make this work much better. Is there a way to limit the range it is looking in? For example, With ws1, it looks in .Range("F7:F"... Is there a way to make it only look from "F7:F106"?

Thank you for your time

Yup. You would just say something like this:

Please Login or Register  to view this content.

Originally Posted by stnkynts

Yup. You would just say something like this:

Please Login or Register  to view this content.

I did not get a chance to say thank you for your help earlier. The code is working great for me!

Thanks

Glad is it working for you. If you get a chance please mark this thread as solved and feel free to give me rep (star on bottom left of post) if you feel I deserve it.