Question_Multiple Running totals_Same worksheet

[the_real_sportguy0913]

Hello,

I am trying to keep an excel sheet for a formulary at a volunteer clinic for the medications we carry. Part of it will include couple of columns to have the current on hand quantity. I would like one column to have the total on hand quantity, and another column right next to it to have the current amount of medication dispensed. I would like the current amount dispensed column to automatically be subtracted from the total on hand quantity column when a new value is entered. So, it will look like this:

Drug Name, Indication, Dosage, Dispensed Amount, Current On hand
A.....................................................90....................=(1000-90)
B......................................................15.....................=(300-15)
Then, when we dispense again:

Drug Name, Indication, Dosage, Dispensed Amount, Current On hand
A....................................................30.......................=(910-30)
B ................................................................................=(285)

and yet again...

Drug Name, Indication, Dosage, Dispensed Amount, Current On hand
A.................................................... 60...................... =(880-60)
B .....................................................30 ..................... =(285-30)

I have been able to do exactly what I'm looking for for just one row, using a code that I copy and pasted from another forum into the "view code" menu of Visual Basic editor, but I have multiple rows with multiple medications that I'd like to be able to do this for. Is this possible, and can anyone please help me?

Thanks.

T