Hey, what's going on everyone. I just need some help here. In Excel,
I want to create a 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.


--
dj_money
------------------------------------------------------------------------
dj_money's Profile: http://www.excelforum.com/member.php...o&userid=37409
View this thread: http://www.excelforum.com/showthread...hreadid=570893