Find value and copy from different worksheet

I think this is pretty simple for someone who knows there way round VBA, I have been struggling to get it working :(

I am trying to write a macro that will loop through the values in the A column of the 'Jobs' sheet, which I have managed to do.

 What I a having problems trying to do is to use the value from 'Jobs' to get the relevant value highlighted in Green from the 'Values' sheet and place it in the B collumn. The desired output is on the third worksheet.

Could someone point me in the right direction please.

Who is Participating?
Arno KosterCommented:
The formula is to get the sum for specific job numbers, you can build from there.

eg to hide the zero's use

Open in new window

and to highlight it green apply conditional formatting
Arno KosterCommented:
you would not even have to use VBA in order to achieve this
Arno KosterCommented:
wellsoAuthor Commented:
Sorry for the delay answering, top notch
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.