I have three coilumns
H I J
Net VAT TOTAL
I need to work out how once we enter each nett it will work out the vat and total. (iideally it can also work backwards from the total>vat>net)
However as we have a lot of entries I wonder if there is a way of making the whole collumn do the same sum rather than having to enter the forumla in each relevent box
I can then do a totaliser at the bottom of each collumn.
any help mucho apreciated