Inventory update with macros.

Hello all.

I have a workbook with 3 spreadsheets for my business.

#1 is the main "interface". Here it display the ticket that will be printed in a thermal printer. I have four rows for items, which are selected from the drop down list (data validation). The list of items is in spreadsheet # 2 and it has the prices on a second column. When I select an item from the drop down list, it fills the price using vlookup. Then, I input the quantity and it gives me the total. Each of the four rows is the same and below all, it gives the grand total. All this info then is saved in the 3rd. spreadsheet. I created 3 buttons and assigned macros: 1 for printing the ticket (and it saves the info also), another one for just saving the sales info (if customer doesn't want a ticket) and a third one to clear the info (in case the sale doesn't happen). The inventory is on sheet #1 also, it's a simple 2 column (item and quantity) and I have to manually update it when I make a sale, but sometimes I forget to update it

I created 4 macros also: 1) for saving the sale info from #1 to #3 spreadsheet. 2) for printing the receipt. 3) for clearing the fields in case of "no sale" and a last one to update the ticket number (incremental).

How can I create a macro that will check all four rows of items in sheet #1, check the quantity sold for each item, and then update the inventory? I tried some of the examples shown in the forums, but no success.

I have attached some pics.

Thanks all for your help.

macros.jpg

note 2.jpg

Sorry about that.

I added the screenshots and forgot the sample file.

Thanks SMILE.

You really help me and taught me something new (variable loops)