Calculate value without changing its total

[Kundankumarpa]

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.........

[StephenR]

Please post a workbook.

[Kundankumarpa]

Dear StephenR,
i am sending the workbookBook2.xls

[StephenR]

Are there no other constraints? It seems as though there will be many possible solutions - eg In values could be 10/16/1/27 and Out 7/1/9/17.

[Kundankumarpa]

yes may be possible that it have some more solution but it is not illogical and hence it can be programed in macro
so please help