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!!