Hi all,

I want to create a expense account sheet that basically has a column for the VAT amount, a column for the net total, a column for gross total and then a series of columns identifying what the expense is (ie: petrol, food, hotel etc) and the NET amount in the appropriate one. If the sales person can enter just the nett amount in the appropriate expense column does anyone know if it's possible to then calculate everything else via formulae, and if so how, or are macro's unavoidable?

Thank you in advance!

Karen