🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac
Article #10992

Updating a large database in EXCEL

#10992
From: Melchor A Meilchen
Date: Fri, 23 Mar 1990 23:31
18 lines
1118 bytes
I have been trying to write a macro in Excel (so far unsuccessfully) 
to do the following for a large (3000 row) database in Excel:
The user would put the Item # and quantity in the CRITERIA range.

The macro that I need  would then:
do a search for the Item # in the DATABASE, select the DATABASE item 
quantity, and update (add or subtract) the quantity
with the quantity from the CRITERIA range. It would then get ready 
for the next input of item # and quantity in the CRITERIA range.

Any ideas as to what function I should utilize?

Please, PLEASE help!

Also please reply to roskar@jhuvms.bitnet as this account on unix is $$.

Thank you all so much.
VELJKO 
Technical Details
Message-ID: <4558@jhunix.HCF.JHU.EDU>
Path: arc1-ca.pugleaf.net!utzoo!attcan!uunet!tut.cis.ohio-state.edu!zaphod.mps.ohio-state.edu!uakari.primate.wisc.edu!uflorida!haven!aplcen!jhunix!mel

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!attcan!uunet!tut.cis.ohio-state.edu!zaphod.mps.ohio-state.edu!uakari.primate.wisc.edu!uflorida!haven!aplcen!jhunix!mel
From: mel@jhunix.HCF.JHU.EDU (Melchor A Meilchen)
Newsgroups: comp.sys.mac
Subject: Updating a large database in EXCEL
Message-ID: <4558@jhunix.HCF.JHU.EDU>
Date: 23 Mar 90 23:31:25 GMT
Reply-To: mel@jhunix.UUCP (Melchor A Meilchen)
Organization: The Johns Hopkins University - HCF
Lines: 18