I agree with JoAnn on this one. Excel is very poor at keeping track of
perishable inventory (parts you buy/sell), Access would be better suited.
I know a couple of people who run small repair/custom building shops for
computers and they use a database type application to 'manage' their
inventory - one is actually some old DOS-based ISAM type db, but it is a
database application, not a spreadsheet type.