Forum Discussion
Parts inventory
Hello, im getting together a parts inventory. Im searching for a formula that when i receive my parts packing list with received parts i can enter in my part number and it takes me right to where it...
All i want is my search bar where i enter in a parts number to locate where in the parts # is in line A and line I the current inventory amount.
Hi Shareena
Here play with this
you select the part number using a drop down, you can type a few of the number to narrow your search in the drop down list:
for example, you type HK in the drop down then press the drop down arrow:
then press ctrl+alt+F5 to refresh the search screen
then it will show the stats related to the part number and the row its located in the inventory table