Shopping system Help

  • Thread starter Thread starter stepers1
  • Start date Start date
S

stepers1

I am trying to make a shopping system and it has to be in excel. I nee
to be able to select an item from a stock list and then it shoul
automatically take 1 away from the stock level.

I hope you understand what I am trying to say.

Please help me if you can
 
Hi
I think you have to explain your expected result with a little bit more
detai:
- what do you mean with 'shopping system'
- How do you want to 'select' an item (A listbox containing your items
is easily created -> try data validation)
- What do you mean with 'takin 1 away'. Do you want to reduce a cell
value atuomatically or wouldn't it be better to store the starting
value and calculation all removals

Maybe you can give us an example of what you're trying to achieve. That
said IMHO normally a database would be beeter suited for a real
shopping system

HTH
Frank
 
To expand on the above answer, normally a system like that
will track how many of an item you purchased, and how many
you sold, so your current inventory would be a
calculation. And then if you have returns, well, you see
it can get messy.
 
Back
Top