hello,
I am new in excel vba and have some problem to solve a sheet, which is as follows:

Previous IN OUT TOTAL NEXT
9 27 17 19 12
12 0 0 12 27
27 0 0 27 19
48 27 17 58

In Total Couloumn formula is (Previous + IN - OUT)

I have to make value of 'TOTAL' = 'NEXT' by changing the nos in 'IN' and 'OUT' without changing its (IN, OUT) total

e.g. first row of NEXT is 12, i have to convert 'TOTAL' value to 12 also hence i will change "'IN'1" to 20 and "'IN'3" to 7 it now value in 'TOTAL'
will be 19 and sum of 'IN' (27) will not change.

if anybody interested, please support
Thanks in advance.........