View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dj_money[_2_] dj_money[_2_] is offline
external usenet poster
 
Posts: 1
Default Is This Embedded in The COUNTIF() function???


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 lin
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() functio
that Counts how many Aisle there was for this product TOY. I als
would like to display the AISLES within the same ROW too!!! Basicall
I want it to display it like this:

Column A1: Toy
Column B1:
_<--_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,
really need your help on this

--
dj_mone
-----------------------------------------------------------------------
dj_money's Profile: http://www.excelforum.com/member.php...fo&userid=3740
View this thread: http://www.excelforum.com/showthread.php?threadid=57089