I have created an Excel spreadsheet that I am using to keep a record of all available inventories in stock. I want to know is it possible to create a function that would automatically remove a single item from the total amount available a row when I enter the word “Sold” in the cell corresponding to that item and when all items are sold out would automatically delete that row.
For example in row 16 I have an Item listed and the number of stock available at 6. I want to enter the word sold and have the number available change to 5, and when that number gets to 0 item the row would delete itseld.
Bookmarks