Make a spreadsheet with "sorting" columns.
These are general descriptors, then a description and location , and location can have sorting too.
Example, using ","to separate items, header example then item...
Cat,type,qty,description,loc type,location, location sub
Consumable,sandpaper, 5, 6x48 sanding belt for delta, file cabiner,west wall, drawer 2
This allows sorting with the column filters as well as simple word search.
We have about 1200 lines in the sheet and saves boatload of time
Just need old pc in shop
Sent from my SAMSUNG-SM-G930A using Tapatalk