Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!uflorida!haven!aplcen!jhunix!mel
From: mel@jhunix.HCF.JHU.EDU (Melchor A Meilchen)
Newsgroups: comp.sys.mac
Subject: EXCEL database help
Message-ID: <4520@jhunix.HCF.JHU.EDU>
Date: 19 Mar 90 16:14:53 GMT
Reply-To: mel@jhunix.UUCP (Melchor A Meilchen)
Distribution: usa
Organization: The Johns Hopkins University - HCF
Lines: 14

I have been so far unsuccessful in implementing a macro for an Excel 
database of ~3000 records (rows).  What I need is a macro that would
take a NAME and a NUMBER from the Criteria range, look up (find) the NAME 
in the Database, and subtract / add the Criteria NUMBER 
from/to the Database NUMBER.  It would then prepare itself for the next 
entry of NAME and NUMBER in the Criteria range.

I guess this is sort of an inventory management technique.
Is there an EXCEL function (command) that would take a value in a cell 
and add/subtract a value typed in the "command" line?

Please help, any replies are useful!

Veljko Roskar@jhuvms.bitnet