EXCEL database help

Article View: comp.sys.mac

Article #10693

#10693

From: Melchor A Meilchen
Date: Mon, 19 Mar 1990 16:14

14 lines
1054 bytes

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

Technical Details

Message-ID: <4520@jhunix.HCF.JHU.EDU>

Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!mailrus!uflorida!haven!aplcen!jhunix!mel

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!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