Compare a cell value to a range of values, copy offset cell

Morning,

I have a range of values within ("B6:B57") (lets call it B_range) and another range of values within ("E6:E57") (lets call it E_range).
B_range can change and it is data that is pasted in earlier before the macro is run (they are varying week numbers mixed up).
E_range remains constant, (they are week numbers in order from W01 to W52).

If a Value in E_range, lets say "W06", matches a value in B_range, (another "W06"), then the value offset by (0, 1) to B_range needs to be copied to the empty cell offset (0, 1) to corresponding the E_range value.


The only thing I can think of is very long winded, Im sure theres a much easier and faster way:

Please Login or Register  to view this content.

And then this code would just be repeated another 51 times... VERY LONG!


Any help greatly appreciated!

Just reading through the code, that seems very close to what I need...

The only problem is that the range in B column will be mixed, so it will not always match the week numbers directly offset by (0, 3).

eg. W01 in B_range may not be opposite W01 in F_range. It may be further down the list.

You are a God.

Thank you very much!
Case Solved.