Hi, i'm trying to use VBA to retrieve an input of the quantity sold for the particular item and it will then do a deduction of the goods based on its item in the inventory worksheet, something like stock counting.

There is a button now that allows user to click whenever item is sold, so this button should have vba that would allow me to search for the item in the other worksheet and does the deduction of the quantity from the list

C9: Quantity input by user in Jenny worksheet
B:B List of items in the Inventory worksheet


Please Login or Register  to view this content.