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).
Bookmarks