So for some pre-climatic info, I have a Cache inventory of fire gear and equipment on one worksheet with totals of what we have in stock in one column with a preset required amount in another column. I have a hidden column making calculations that then tallies in one column any overstock or in a separate column a numbered count of that item needed based on what we have in stock to whats required to have in stock.
What I am trying to do with that info is in another sheet make an employee checkout/issued form/sheet that when a certain item is select from a drop down list, that is referenced back to a named range I have setup, I then in a cell next to the drop down box put in a count or number of items issued that would then alter my other sheet to subtract it from my overall count of such item and in another column show a numerical count of said items checked out.
I will upload my excel doc for reference. The sheet labeled Fire Gear and Supplies is the cache of items that could and would get issued to employees for the fire season. The worksheet that says Checkout is the sheet I am trying to make the checkout sheet on that once i select from the list the item I then under issued will enter a number of issued items that would then subtract it from my other sheets total of the individual item and then in the column labeled Issued would show the quantity of the item issued.
Bookmarks