excel inventory spreadsheet
I’m new to excel and I’m needing an inventory spreadsheet that will continuously update based off my order entry.
I have 3 separate tabs for the inventory, ”adult t-shirts” “youth T-shirts” “tumblers” and 1 ”active order” tab. is it possible to track the inventory by simply inputting an order?
example: if i enter an order ” X customer, gliden Cotton, 1 item, white, Large, Adult” how can i have that order subtract the number of items based off brand, color, size and if adult or youth?
IS that even possible?
I’m new to excel and I’m needing an inventory spreadsheet that will continuously update based off my order entry. I have 3 separate tabs for the inventory, ”adult t-shirts” “youth T-shirts” “tumblers” and 1 ”active order” tab. is it possible to track the inventory by simply inputting an order?example: if i enter an order ” X customer, gliden Cotton, 1 item, white, Large, Adult” how can i have that order subtract the number of items based off brand, color, size and if adult or youth? IS that even possible? Read More