Hi Everyone, again, sorry for a confusing topic.
I am creating a spreadsheet for my mother-in-laws croassant bar (you might have seen my first request of help here yesterday).
The purpose for this is to help her control what is being sold and whatnot since we cannot trust the employees of this very small business of hers.
I had the help of Alpha Frog here on my first request, thanks again Alpha Frog. Here he helped me to create a macro where all sales would be added onto another sheet called Short (for sales).
I am not sure who can help me on this second request, but appreciate all help:
Macro 1) By the end of every week (Saturday) have the values of "Short" automatically sent and subtracted on sheet called Estoque (stock in Portuguese). All croassant flavors will be added, we just want to know the total number of croassants sold (either normal or whole grain - integral). The names of the products in "Estoque" are on column A and should match names on the rows "Short", value should be subtracted on Column B.
Macro 2) Every time she goes to purchase something, she goes to sheet Compras (purchases in Portuguese) and inputs whatever she bought on column B. Column A has the names of the products that matches sheet called 'prices', when she has finished inputting, a button is pressed where all the values will be added to column B in estoque.
With the above macros, I am trying to achieve a kind of stock control, where at the end of the week she will know what needs to be bought, what was sold, what was missing. Does it make sense to any of you? Can someone help me? :D
Attached is the spreadsheet. Again, most macros were made with the help of Alpha Frog, I am not good in programing at all.
Bookmarks