I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so:
Column I = Current quantity
Column J = Enter any...
Can anyone help me please!
I want the information I have obtained via a form to update individual records.
I've created a sub called PersonSearch and a variable "Person" to hold the value from the list box, if found it calls the EnterDetails sub.
The names are in a worksheet called...