Need code [Automatically calculate new results as values are entered on other sheets]
Need code in cell "I3:I1000" for sheet2,3,4,5..... so on respectively in order to reflect changes in cell "P7:P1000" of sheet1. Whenever i type any value in cells "I3:I1000", it should be reflect in cell "P7:P1000" of sheet1.
For eg: Sheet 1 : P7=10, I inserted value in sheet 2: I3=5. So i want the vale to be deducted from cell P7 automatically. It should be like this,
P7= 10-5 = 5
Cell P7 in sheet 1 should reflect value 5.
Please give the code for the above.
Thanks
Need code in cell "I3:I1000" for sheet2,3,4,5..... so on respectively in order to reflect changes in cell "P7:P1000" of sheet1. Whenever i type any value in cells "I3:I1000", it should be reflect in cell "P7:P1000" of sheet1.
For eg: Sheet 1 : P7=10, I inserted value in sheet 2: I3=5. So i want the vale to be deducted from cell P7 automatically. It should be like this,
P7= 10-5 = 5
Cell P7 in sheet 1 should reflect value 5.
Please give the code for the above.
Thanks
