Questions

excel spreadsheet for inventory management

Tags: Community
+
0 Votes

excel spreadsheet for inventory management

alxg823
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.

Member Answers

    • +
      0 Votes
      willis0966

      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.

      Willis0966

    • +
      0 Votes
      willis0966

      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.

      Willis0966