data indexing macro

Hello first up many thanks for taking the time to look at my problem! The problem essentially invloves offsetins some data and replacing one of the values based on indexing a name in a one list, and locating it in the next :S Very hard to explain! Please see example much clearer!

Many thanks

Alan