Run macro when data in cell is entered

[VishalGupta]

Hi all,

I have to run a macro which is based on the formula A = A - B. I have a 8x3 grid where the columns are Total, Current, Remaining. 'Total' will have details entered by the user initially. 'Remaining' will initially take up values of the 'Total' column. Now I want that when data is entered in 'Current', 'Remaining' should automatically calculate:

'Remaining' = 'Remaining' - 'Current'

I tried writing a code in the Worksheet Selection Change window but that just runs the code every time cell selection changes which gives inaccurate results. Is there a way that the formula is calculated only when the data is entered in the cell and the user moves into the other cell? I hope I have been able to express the problem clearly.

[Mordred]

Hi vishalgupta,
I am confused, you want column 'Remaining' to equal the Total column initially, and then you want the 'Remaining' to equal 'Remaining' - 'Current'. I don't think it can be both at the same time. If you could clarify this we will be able to help you better.

Thanks

[VishalGupta]

Hey Mordred,

The description above was a simplified version of the actual problem. The real problem involves the user entering the number of quantities he wants to be transported. But he will transport them in smaller quantities. So ideally, I want that there should be 3 columns, one which shows the original quantities entered, one to enter quantities to be shipped currently and then the last one showing how much quantities are actually left after all the shipments. That's why 'Remaining' will take up values of 'Total' initially and then its value will be based on the formula.