Hi! I run a tennis club and I was hoping to use excel to track some of my inventory. Basically, I have 10 pros. They each use a set number of items. For example, I use 2 cans of balls, 1 set of strings, and 3 bottles of water per lesson. Each coach has a different number, but I was wondering if there was a way for me to connect each amount to a Coach and when I type the Coach's name into a field, it would automatically subtract the variables from my overall inventory.
Sorry if that doesn't make a whole lot of sense. But here's an example:
Pro #1:
2 Cans of Balls, 1 Set of Strings, 3 bottles of Water
Lesson:
Yes
Pro #2
3 Cans of Balls, 2 Set of Strings, 2 Bottles of Water
Initial Total Inventory
100 Cans of Balls, 100 set of strings, 100 bottles of water remaining.
New Total Inventory
95 Cans of Balls, 97 Set of Strings, 95 Bottles of water remaining.
Thank you so much to whomever can help me!!!
Sorry if that doesn't make a whole lot of sense. But here's an example:
Pro #1:
2 Cans of Balls, 1 Set of Strings, 3 bottles of Water
Lesson:
Yes
Pro #2
3 Cans of Balls, 2 Set of Strings, 2 Bottles of Water
Initial Total Inventory
100 Cans of Balls, 100 set of strings, 100 bottles of water remaining.
New Total Inventory
95 Cans of Balls, 97 Set of Strings, 95 Bottles of water remaining.
Thank you so much to whomever can help me!!!