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.




Example.xls
LVL 2
wellsoAsked:
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
=IF(SUMIF(Values!A:A,Jobs!A2,Values!I:I)="";"";SUMIF(Values!A:A,Jobs!A2,Values!I:I))

Open in new window


and to highlight it green apply conditional formatting
0
 
Arno KosterCommented:
you would not even have to use VBA in order to achieve this
0
 
Arno KosterCommented:
0
 
wellsoAuthor Commented:
Sorry for the delay answering, top notch
0
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.