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
Bookmarks