Hi there
please Help: Trying to create my own personalized inventory system for my manufacturing center. Basically i have a table in a sheet with a list of stock items on hand, which i need linked to a delivery note system for items coming in and out. My problem is i have a drop-down (on the delivery note to the corresponding item on the stock list. I.e. If i randomly select a product from a drop-down list on my delivery note, it must update that specific item on the stock sheet, the problem is how do i link the items.
i have a sheet attached it will be easier to explain with this.
Bookmarks