Hi Richard,

Thank you so much for your help - I really appreciate the time you put into this.

One thing (and maybe I should have been more clear in my example or written it in a different way), but instead of copying and pasting all the data into a new section on the same sheet, is there any way the macro can simply adjust the existing data where it is? No need to copy or move anything. I just used the before and after in the same sheet to illustrate the difference.

Your macro seems to do all the merging and matching just fine - just wondering if there is a way we can perform these calculations on existing data and not copy or move. Does this make sense? Sorry if I had caused any confusion in my example and again, I appreciate the help.