Using Multiable sheets for Invertry Control

Copper Contributor

I am using multi able sheets for inventory control,, right or wrong  ,,it working ok.

each sheet has a cell set aside for the part number , order number etc.

i can search for order number through ctrl f  or find all , it displays a list of all sheets where that order number appears, and from there eg, select the first on the list  , i get taken to the sheet ,if it is the wrong item , in then have to the next line in the list of find all until i find the right part number .

I can make a query that lists all the sheets that have that order number in the sheet cell, including the part number found relating to that order.

I was trying find a way to now ,using the query list , to select a part number , for that order query  and jump back to the sheet where that part number came from so i can edit ..

hoping this is explained right



1 Reply
I am trying to do what "ctrl f" does with more info available using the query list , as ctrl f does not allow expansion of headers , if query could do the same I could save a lot of time updating sheets,
I explored Access however the history i need at a glance is more suited to excel and a sheet per item .
any thoughts or suggestions appreciated.