Hello there. My little excel project is almost done. It's goal is to make a functional bill that affects the stock. Last thing I need to do is to make the stock decrease according to the number of selected quantity when I'm done entering the components. I have a separate sheet for my bill and a seperate sheet for stock. I've tried for hours without any result. If you have any suggestions please answer. My idea was to have 3 states of project which would affect the stock. 1 would be none (not working), 2 would be editing, and 3 would be to save and decrease stock accordingly to entered quantity, but it failed.
bill sheet
Zajeta slika – kopija.JPG
stock sheet
Zajeta slika2.JPG
Bookmarks