ah, the days of reinforced punched hole ... I remember them well.

Have a summary sheet with the names of the medicines in A2:An, then in B2

=SUMIF(Sheet1!A:A,A2,Sheet1!E:E)-SUMIF(Sheet2!B:B,A2,Sheet2!F:F)

where Sheet1 is the stock list sheet with the name in A and E the num,
Sheet2 is the dispensed sheet with name in B and F the num. Then copy down.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Kazdagi" .(donotspam) wrote in message
...
Ok, I thought this would be easy enough but the answer keep avoiding me.

I work in a small rural clinic and we get a lot of sample medications that
we provide to folks that cannot afford medicines. For about 3 years now I
have watched managment mismanage this inventory. Paper everywhere,
notebooks
filled with reinforced holes in sheets that are folding over and driving
me
crazy. There has got to be a better way of tracking this maddness . . .
Creating a spreadsheet to manage the meds is not hard, nor is one to track
meds dispensed to patients. What I am trying to do is create something
that
has a accurate running total of meds in house. Say if I give 30 tablets
of
drug yuckie to a patient I would want 30 subtracted from drug yuckie
total.
Sounds easy but is totally perplexing to me. I have tried two pages -
first
page with labels such as Name of Med., Strength, Lot #, Exp. Date, # of
tablets. Second page labels include date, Chart #, Name of Medicine,
Strength, Lot #, Exp Date and # of tablets dispensed (which I want to
subtract from the original number of that medicine and refresh the total
to
reflect the new value. And I can't do it. Help and direction is what I
need
- and perhaps someone that finds this very easy and interesting. I hate
seening thes binders and stacks of papers cluttering up workspace. . .
there
must be an esier way! Thanks again,

Kazdagi
--
It is getting harder and harder to concentrate . . . what was I saying
again?