Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CountIf embedded in an IF statement Amber Excel Worksheet Functions 8 July 30th 07 07:44 PM
Embedded If Function in a Vlookup Function Excel Student Excel Worksheet Functions 2 January 13th 07 04:39 AM
Embedded VLOOKUP function within IF function beautyteknorth Excel Worksheet Functions 6 August 17th 06 09:31 AM
Is This Embedded in The COUNTIF() function??? dj_money Excel Worksheet Functions 1 August 11th 06 09:54 PM
LinEst embedded in VBA Function Warren H Excel Programming 1 November 12th 03 01:45 PM


All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"