Greetings,

I am very new to using VBA and I have run into a problem of which I hope there is a simple solution.

I have a worksheet that contains inventory data and quantities located at two different locations. I want to create a UserForm to edit/amend those quantites based on one of the two different locations.

I know how to create a UserForm and will have a combobox for the Item Code, textbox for item name, textbox for Item Description, textbox for Quantity to Add/Reduce. I will also have a cmdbutton to Update Quantity.

In addition, I believe I would like to have a separate worksheet to use as a log to record each entry.

I have attached a sample representing the Master Inventory worksheet.

If anyone can help, I would very much appreciate it.

ThanksSampleWS.xlsx