Article View: comp.sys.mac
Article #10992Updating a large database in EXCEL
From: Melchor A Meilchen
Date: Fri, 23 Mar 1990 23:31
Date: Fri, 23 Mar 1990 23:31
18 lines
1118 bytes
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!melShow 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