Hello. I am trying to run a macro that automatically updates our stock sheet.
Basically what I have is sheet 1 (Stock Sheet) with a product range in Column A, a +/- column B and column C is the stock quantity.
On sheet 2 (Scanned) are the scanned product codes (incoming stock) in column A and the scanned quantity in B.
So ideally the macro would loop through matching each incoming product code on sheet 2 with the master on sheet 1 and then input the corresponding new quantity in the +/- column next to the product code. Once there I have a command button to add/subtract it against the total.
I have been trying to embed the .Find command into a For Each loop to accomplish this but so far have not had much luck. Is this the best method to go about this?
Here is the code I have been working with to give you an idea.
Please Login or Register to view this content.
I have attached a sample spreadsheet which shows how the data is set up.
Any input on this is much appreciated and thanks for your time.
Copy Simple Stock Sheet.xls
-James
Bookmarks