Creating a searchable global inventory database

Mark in Saudi

Good afternoon everyone

Trying to get some inspiration as to a good template with which to start from.

I want to create a template that would show all our company inventory, by location, for example USA or UK, but would also need to be searchable by item, so if a person wanted to know where an item is, they could just type in the item name and the various locations would appear showing that item.

If anyone has this sort of template or could point me in the right direction of how to start this i would be eternally grateful

Much appreciated for taking the time to read my short post.

bilism_kaley

create columns for items, locations, and details. Use filters and the search feature for quick access, templates or custom sheets can give a good starting point!