General discussion


excel spreadsheet for inventory management

By alxg823 ·
Tags: Community
I was curious what i would need to do to create an inventory sheet. Specifics: i would like to be able to input my inventory and then on another page input each invoice and type the item in | or drop down from a menu and have it subtract the quantity from the inventory.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Inventory

by willis0966 In reply to excel spreadsheet for inv ...

In my opinion, you're trying to use Excel as though it were a database program. If you know how to use Visual Basic for Applications, it isn't impossible. If you want a reasonably "nice" user interface, why not use MS Access? Even then, you'll end up having to do some coding.

I'm a mostly self-proclaimed "expert" with Excel and honestly, I don't know if I would want to spend that much time writing code to do what you want to do. Maybe, if you're young enough, and you get started right away; you could get something that you like before you retire.

What you want to do is not difficult - if you just want to reduce the count on a spreadsheet that has the quantity on-hand. However, you would need to "validate" the entry on the invoice and "search" the inventory sheet to perform the arithmetic.

If you hold a gun on me and pay me enough, I would do it. But, if you don't have a gun, I wouldn't.

Good luck & learn Visual Basic.


Related Discussions

Related Forums