i want to program an excel doing that For Example if I have a 5 as an amount
of something I need to automaticallu reduced when I entrr data like bill no.
or bill date in a blank cell as an example:
A B C D E
1 amount sell date Bill no sell date Bill no
2 5
3
4
5
as we see I want if I fill the Empty Blank like the following to
autmatically reduce the amont
A B C D E
1 amount sell date Bill no sell date Bill no
2 5 4/1 0030
3
4
5
So Whwnever I enter any data in the blank cell in B2 or C2 or D2 or E2
automatically reduces 5 to 4
I hope you got what I want I'm using Excel 2003 Thanks For All