Look up
 

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