Trying to keep formulas in place after sorting data!

[Ian1976]

Hi Fluff/Everyone,

HNY!

https://1drv.ms/x/s!Aszg_mMOoSFEgRyt-qUa9uRsOkZG

Could you have a look at my spreadsheet and tell me if there is a way of keeping the formulas in the same order as the rest of the data after sorting it using the buttons?

I had a play with changing the formulas to absolute but can't figure out where I'm going wrong?

Thanks
Ian

 

[Ian1976]

Forgot to add that I have altered theformulas in column O the allow a variable figure in AD32 to be used!
But after sorting the data all the formulas goes sideways??

Hi Fluff/Everyone,

HNY!

https://1drv.ms/x/s!Aszg_mMOoSFEgRyt-qUa9uRsOkZG

Could you have a look at my spreadsheet and tell me if there is a way of keeping the formulas in the same order as the rest of the data after sorting it using the buttons?

I had a play with changing the formulas to absolute but can't figure out where I'm going wrong?

Thanks
Ian