fill column when a row criteria was satisfied

[mortred]

pls help with the code

its a database, that will search for id # in a certain column
and will encode additional data on that row if it returns a value that is true

[mdmackillop]

I think we need a bit more information. What are you searching and how is the data returned? When is a column "full"

[mortred]

i wanted to make an inventory tool that uses a userform to add items to database.
also it has an option to search added items to said datase and has an option to withdraw certain quantity...
there are instance the quantity to be withdrawn are not the full quantity or only partial withdrawal.
i wanted also to delete the item in the inventory when the full quantity are withdrawn or if partial the quantity, remaining quantity will be be updated database.