I have an inventory list of stock, but multiple items are used in every one product i sell (e.g every time I sell a flower hair tie, I decrease in one flower, one clip and one gem). I'm looking for a way to create a button that I can press to subtract one from every item of stock used in that product. So for example if i clicked my flower button my inventory would show that I had one less flower, clip and gem but if i pressed my broach button I'd have one less flower, gem and clasp. Do I have to create a Macro? please Help
Bookmarks