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.