Jindon,
This works very well for the first 9 items, but stumbles when it gets to "Coke". The store numbers should correspond to the lines beginning with "Quantity". So, for the example "Coke", store 0 should correspond to 0, store 1 to 3, store 2 to 0, store 3 to 6, etc. I know it's strange. Also, it stops right after the coke example. If I had more lines, perhaps 25,000, how would I get this to work?
Thank you again! I appreciate your help!