Hi David,

Sorry, yes, you are absolutely right. I was half asleep.
What I should have said was not =B1+A2 but =B$1+$A2
That will fix the row 1 and column A references accordingly, and allow the
rest to update.

Amazing, it's that easy :)

Thanks a lot, this has saved me hours of manually adjusting it - it
never crossed my mind that it's so straight to adjust the "fixing $"
though ;)

Thanks again,

Chris