Hey, what's going on everyone. I just need some help here. In Excel, I want to create a VBA that uses COUNTIF() function that would link data from another Workbook (Source). My Source Workbook displays:

Column A1: Toy
Column A2: Toy
Column A3: Toy
Column B1: Aisle 4B
Column B2: Aisle 6C
Column B3: Aisle 6A

However, IN the Destination Workbook I've done a COUNTIF() function that Counts how many Aisle there was for this product TOY. I also would like to display the AISLES within the same ROW too!!! Basically I want it to display it like this:

Column A1: Toy
Column B1: 3 <-- this is comes from the countif function
Column C1: Aisle 4B
Column D1: Aisle 6C
Column E1: Aisle 6A

So, Exactly how can I accomplish this guys and ladies? Thanks, I really need your help on this.