Forum Discussion
simple way to create a supplies ordered / inventory SS that is broken down into mini categories
- May 05, 2024
See the attached workbook for one possible solution. Read the notes on the _Info worksheet.
The "best solution" depends on information we don't have (unless we have a working crystal ball).
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
(Same doc saved in same place)
Below is a video tutorial that will give you a good foundation on what it is you're trying to do.
https://youtu.be/ohGFPF12Qwc
The tutorial comes with working files you can download to follow along.