Inventory and Sales Linking Data

[shjenk1]

I am a crafter and have an inventory sheet that I use. All my crafts are numbered and labeled. I sell my crafts at craft shows and what I would like to do is create a new sheet for each show I attend to track sales. I would like somehow to be able to put in the item number on that new sheet and the amount of each item I sold and have that link back to my original inventory sheet. Ideally, it would subtract the items sold from my inventory, to keep that sheet accurate. Is that possible, or do I need to just do it manually for each show I attend?

[Richard Buttrey]

No, there will be a way to do this with Excel. However you'll need to upload the workbook for more specific advice. Be sure to add a manually calculated worked example.