Code to allocate a value 1 row at a time until the variance between 2 cells disappears

Hi

I hope i can explain this properly! I need a macro to round cells to 2 decimal places and then find the variance between the total of these cells and a cell price and allocate pennies to each row so that there is no longer a variance

Untitled.png

Example - if you round the attached figures up they come to 7196.42 rather than the 7196.44 they need to add up to.

The macro need to allocate the 2p difference to a line - i am happy for the macro to go through each line until the variance is gone.

I dont think this is an easy one! Sorry!!

This may explain it a little better

Cell C81 is 7196.44
Cell A12 is 7196.42

I need a macro to add 0.01 to each row (column A) until C81 and A12 match

This really has me confused!