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

		Microsoft Office Forums > Microsoft Excel > Excel
Inventory-Trying to add numbers to a total based on the numbers above.

#10

07-17-2017, 08:29 AM

NoSparks

Windows 7 64bit Inventory-Trying to add numbers to a total based on the numbers above.

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

That Aisle part was not indicated in your sample.
To accommodate this in my code change this line

Code:

If arr(i, ii) <> "" Then

Code:

If InStr(arr(i, ii), ";") <> 0 Then

What "other cell" are you wanting to put the value(s) into ?
And what does your ID;Amount data really look like ?

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need Excel to recognize week numbers based on specific dates	Ktyler	Excel	5	02-06-2017 11:08 AM
Open a document based on a template, the page numbers in the TOC won't update	billy8b8	Word	2	10-04-2015 06:06 AM
Search a cell that contains words and numbers and convert the numbers to metric	Carchee	Excel Programming	36	10-08-2014 03:16 PM
How do I refer to page numbers, when the numbers change as I prepare the document?	StevenD	Word	5	11-29-2012 12:52 AM
Create index based on bullet numbers	EZRider	Word	0	07-10-2009 09:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:30 PM.