Inventory-Trying to add numbers to a total based on the numbers above.

[beeker223]

I'm trying to make an inventory spreadsheet that scans for numbers in the spreadsheet and then adds the amount of the said item to a total value in another sheet. There is a warehouse and products can be everywhere, but I do not know exactly which products will be where.



Numbers are written into said spreadsheet as 1001(ID);60(amount). Then underneath that I am pulling the numbers before the semicolon, and after the semicolon. These numbers are below in ID and AMOUNT sections in the spreadsheet. I just need a way to scan for all the numbers and then pull the number below it into a total value that when all the values for that product are pulled, will display the total amount. (Sorry for the convoluted and messy explanation).Keep in mind that the numbers may change and there will be around 800 different items. Sorry, I understand that this may be very easy, but I am very inexperienced when it comes to any sort of VBA code like this requires (or I believe requires)

Add amount here is where I want the totals to be added, but I moved them 1 to the right to show this. The data should be entered correctly and what I want it to do is scan/search for a number, and based on the number, add it to the corresponding total value.

Thanks, Daniel