How to set up minimum and maximum quantities on master inventory sheet.
Also, add a column for a name to input for the person checking out items.
The minimum and maximum quantities I would solve by using conditional formatting.
As a result, cells would be flagged red whenever quantities entered are more than max and less than min.
And of course, you can add an additional column but make sure to append it at the end to not interfere with the existing column structure.
I think I understand what I need to do next.