hi,
I have c column in my spreadsheet with a formula in it like:=E8+F8-D8 IN C8
CELL.
E8 and F8 are change manually resulting changes in availability(C8) but the
content of D8 comes from another source and it's change off an on.the problem
is ,say E8=10, F8=20 and D8=12 ,so the C8 comes to 18; now when the D8
changes to 8, the C8 changes to 22 but what I need is maintaining the
previous quantity as 18 and after D8 is turned to 8, the new C8 be 10.
I hope I was able to convey my problem clearly to you.
colu. A col. D
col. E col. F
=E8+F8-D8 (=18) =xx(=12)
10 20
=22 but i need (18-8=10) (now if xx=8)

so is there any way to keep the previous qnty constant?!!
thanx for your time.

Sounds like you need to make D8 an accumulator:

http://www.mcgimpsey.com/excel/accumulator.html

In article ,
peyman wrote:

hi,
I have c column in my spreadsheet with a formula in it like:=E8+F8-D8 IN C8
CELL.
E8 and F8 are change manually resulting changes in availability(C8) but the
content of D8 comes from another source and it's change off an on.the problem
is ,say E8=10, F8=20 and D8=12 ,so the C8 comes to 18; now when the D8
changes to 8, the C8 changes to 22 but what I need is maintaining the
previous quantity as 18 and after D8 is turned to 8, the new C8 be 10.
I hope I was able to convey my problem clearly to you.
colu. A col. D
col. E col. F
=E8+F8-D8 (=18) =xx(=12)
10 20
=22 but i need (18-8=10) (now if xx=8)

so is there any way to keep the previous qnty constant?!!
thanx for your time.

thanx I'll me check it out.

"JE McGimpsey" wrote:

Sounds like you need to make D8 an accumulator:

http://www.mcgimpsey.com/excel/accumulator.html

In article ,
peyman wrote:

hi,
I have c column in my spreadsheet with a formula in it like:=E8+F8-D8 IN C8
CELL.
E8 and F8 are change manually resulting changes in availability(C8) but the
content of D8 comes from another source and it's change off an on.the problem
is ,say E8=10, F8=20 and D8=12 ,so the C8 comes to 18; now when the D8
changes to 8, the C8 changes to 22 but what I need is maintaining the
previous quantity as 18 and after D8 is turned to 8, the new C8 be 10.
I hope I was able to convey my problem clearly to you.
colu. A col. D
col. E col. F
=E8+F8-D8 (=18) =xx(=12)
10 20
=22 but i need (18-8=10) (now if xx=8)

so is there any way to keep the previous qnty constant?!!
thanx for your time.

bit,I have a range of cells that I need accumulator for them, so how can I
extend the macro for C4:C1800??
thanx

"JE McGimpsey" wrote:

Sounds like you need to make D8 an accumulator:

http://www.mcgimpsey.com/excel/accumulator.html

In article ,
peyman wrote:

hi,
I have c column in my spreadsheet with a formula in it like:=E8+F8-D8 IN C8
CELL.
E8 and F8 are change manually resulting changes in availability(C8) but the
content of D8 comes from another source and it's change off an on.the problem
is ,say E8=10, F8=20 and D8=12 ,so the C8 comes to 18; now when the D8
changes to 8, the C8 changes to 22 but what I need is maintaining the
previous quantity as 18 and after D8 is turned to 8, the new C8 be 10.
I hope I was able to convey my problem clearly to you.
colu. A col. D
col. E col. F
=E8+F8-D8 (=18) =xx(=12)
10 20
=22 but i need (18-8=10) (now if xx=8)

so is there any way to keep the previous qnty constant?!!
thanx for your time.