Forum Discussion

Amber1023's avatar
Amber1023
Brass Contributor
May 02, 2024
Solved

simple way to create a supplies ordered / inventory SS that is broken down into mini categories

I need to track everything our company purchases in a lot of various categories such as Safety Gear and Supplies (PPE, Apparel, Vehicle Parts and Vehicle Maintenance supplies, Tools, Apparel and promo items, Misc small items, Office supplies, Office tech equipment, Shop tools, Shop Equipment, tools, chemical products, hoses, jetters, nozzles, cameras etc, Job site equipment and supplies (totes, tools, sorbents, etc)

I need to make a inventory count sheet that has the items we purchase and links of where we purchase them for easy reordering and include the previous order dates and quantity's so when we do the next count, we have a running list of what we should have in stock and used and use a blank sheet of the categories when we do the counts.

 

I was thinking of Breaking it down into Categories, with subcategories or possibly making a table for each various item and then have a master full list that can be printed and wrote on for inventory counts.

 

I just tried adding a dropdown list in to see if that's the best way but don't want to make it more complex than needed and im horrible at setting the structure up.

 

what is my best solution and how do i set it up?

6 Replies

    • Amber1023's avatar
      Amber1023
      Brass Contributor

      SnowMan55 

       

      thankyou your info sheet is very helpful. I wrote in some questions etc back on the info sheet and added a couple comments on the others.

       

      I have a very good idea of concept as a whole... any chance you could do a video or call with me so i can verify i fully understand? it would make living a whole lot less stressed to finally fix our spreadsheets and get the data into them without guessing.

       

       

      Thankyou SO MUCH

       

      attached is the link to the SS. Idk which works the "share" via drop box
      https://www.dropbox.com/scl/fi/irs9lt4kjflwm6nb3iulm/2024-05-02-AN-inventory-sample-with-questions-back-on-info-sheet.xlsx?rlkey=3a7a8zymo1935poikkk0hn7n2&st=9u2e42bx&dl=0


      Or the share via excel thats saved on dropbox 

      https://www.dropbox.com/scl/fi/irs9lt4kjflwm6nb3iulm/2024-05-02-AN-inventory-sample-with-questions-back-on-info-sheet.xlsx?rlkey=3a7a8zymo1935poikkk0hn7n2&st=ux9pbhuz&dl=0

       

       

       

      (Same doc saved in same place)

Resources