Hello

I am looking for some serious help, i have no idea even how to start creating a macro to balance the two sets of data i have. i have attached an idea of how i would like it to look.

If anyone could help it would be appreciated.

thanks in advance.
CR