Selecting specific data on a worksheet and moving it to a table on another worksheet

After days of trying to solve this on my own with no luck, I need some help.

I have 2 worksheets, B and C.

Worksheet B includes 3 columns. Column A has an item name, Column B has a bin number, and Column C and a quantity number.

Worksheet C has a table with the y axis being the Item and the x axis being the bin number. I need to select the item names on Worksheet B that have a quantity number greater than 0 and then place the item name with the applicable quantity number in the table on Worksheet C under the applicable Bin number.

I figured out how to move the item name using the "If" statement, but I would like to make it in to a loop statement since these quantities are updated daily and the number of item names can change.

Please see my attached Excel sheet.

Thank you for any help. I've been struggling.

I update this workbook (actually another workbook that contains these two sheets and that have many many other sheets with buttons and macros) every hour using XML mapping since the list of item names can change and since the quantity for each item can change (the number of bins never change). I played with your workbook, and if I change the quantity number, the pivot table doesn't update itself (and it doesn't look like there are any macros that allows it to update itself), and since it doesn't update itself, it doesn't look like your workbook will work for me. I need macros that will update the table automatically. Let me know if you have any suggestions, and I greatly appreciate your help.

Can anybody else help me or advise me on what to do?

Thank you very much. This is exactly what I need. Can I ask you a a few questions so that I can learn?

1. what does If, while, and wend mean?
2. what does For i=3 to rcnt do?



Thank you again!

Awesome. Thank you again for the help.