A B C D A
200 200 500 200 200
500 500 200 500 500
600 600 800 600 600
100 100 100 100 100
200 200 200 200 200
1600 1600 1800 1600 1600
The Table is wrong, it's just a format for visual help.
Conditon 1- Where all the values from A2:A6 and C2:C6 should be same
Condition 2- All the total's of A,B,C,D should be same in all Conditions
Condition 3- Where the values in E2:E6 should be in such a manner that E2- C2 should be a positive number not a negative number, and the total of C Should be also the same as of total B.
Condition 4-Again the same situation is repeated again in terms od C to D and then again to D to A, I want to automate the whole process where when I enter the figures in A the rest of the figures must be calculated automatically
Thanks All,
200 200 500 200 200
500 500 200 500 500
600 600 800 600 600
100 100 100 100 100
200 200 200 200 200
1600 1600 1800 1600 1600
The Table is wrong, it's just a format for visual help.
Conditon 1- Where all the values from A2:A6 and C2:C6 should be same
Condition 2- All the total's of A,B,C,D should be same in all Conditions
Condition 3- Where the values in E2:E6 should be in such a manner that E2- C2 should be a positive number not a negative number, and the total of C Should be also the same as of total B.
Condition 4-Again the same situation is repeated again in terms od C to D and then again to D to A, I want to automate the whole process where when I enter the figures in A the rest of the figures must be calculated automatically
Thanks All,