mel@jhunix.HCF.JHU.EDU (Melchor A Meilchen) (03/20/90)
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