I have been writing code but seem to be doing the same over and over again,

what I need to do is, have a macro look through 16 sheets called "a","b"
etc and in column g to lookup any value greater than 0 and when it finds one
to copy it to sheet13 give also the value in column c aswell. is this
possible?

Thanks

Greg

Hi Greg,

Try posting your code.


---
Regards,
Norman



"Greg" wrote in message
...
I have been writing code but seem to be doing the same over and over again,

what I need to do is, have a macro look through 16 sheets called "a","b"
etc and in column g to lookup any value greater than 0 and when it finds
one
to copy it to sheet13 give also the value in column c aswell. is this
possible?

Thanks

Greg