Macro to sort and paste data in specific cells

Hello,

I am completely new to macros, and I have been watching videos for the past week to figure this out. No luck

I need to paste data from the workbook "ADB" to the "Volume" workbook, which are both attatched. "ADB" has 3 columns: account #, item #, and case sales. The only data I need to copy from "ADB" is the data from columns B & C. Column A is simply the account number that the data belongs too. Column B has the item #, and C has the amount of cases sold for that item #.

I would like to copy data from columns B & C in "ADB", and paste it into the "Volume" WB. I would like a macro to put the cases sold data for each item # from "ADB" under the correct item # in the "Volume" WB, for each store.

The first store in the "Volume" WB is #1111 (Cardenas Market #7). In the "ADB" WB, you will notice #1111 carries 18 different items out of the 24 total listed in row 3 of the "Volume" WB.

I am sure there is an advanced macro that could do all of the stores at once. However, I would just be happy with a macro that could do each store 1 by 1. It would still be faster than how we are doing it now.

This was the tutorial I was following, and had no luck.
http://www.youtube.com/watch?v=_sbTZ...eature=mh_lolz

Thanks in advance for all of your help. I have a feeling this is very simple, I just can't figure it out.

ADB.xlsVolume.xls