Re: help collecting data.

Thanks Otto! Sorry I wasnt more specific.. but i'm creating an entire excel
program that does various things so the filter isnt really an option.

I want to type in cell D1, for instance, the product string i'm looking for
.. Product codes are listed in A1:A2000 (2,000 different products) , I want a
code that can search for all instances on the string typed in D1 (only in
column A) .. If it finds the string in Column A, I want it to gather the info
adjacent in column C (say its A2000, I want it to give me C2000)

BUT...

there are multiple product items. I'm basically doing a search for a
product, and I want it to tell me all the order's that included that product
(order numbers are in column C) , So say there are two instances of PRODUCTA
in A1:A2000, it would take each of there respective values in column C and
display them both, seperated by a comma

"452342,3423423"

But there is up to 5 different order numbers so the script would need the
ability to find and display up to five different numbers.

for instance....

COL A COL B COL C
PRODUCTA 10.99 23423324
PRODUCTA 8.99 45345345
PRODUCTB 9.99 23423423
PRODUCTA 10.99 453453453

now if i type "PRODUCTA" in D1, I would like D2 to display

" 23423324, 45345345, 453453453 "

because those are the three order numbers that PRODUCTA was used in..

If there was only 1 instance of PRODUCTA, it would only display "234234,"

so on an so forth..

Thanks again I hope you guys can help me out i'm excel-tarded.

"Otto Moehrbach" wrote:

Brandon
The first thing that comes to mind is to use Data - Filter - AutoFilter.
Look that up in Help. The result would be that all the data rows in the
spread*** would be hidden except those rows that match your criteria. If
you want the result displayed in any other way or in another place in the
*** or the file, you will need VBA. Post back with more detail about what
you want. Otto
"brandon roland" <brandonroland@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:43EA1C9E-FCD5-4479-8726-70740BCB1BAB@xxxxxxxxxxxxxxxx
hello,
another question from the official excel newbie! any and all help is
greatly
appriceated guys!

So I have this list i'm always talking about that has product numbers in
column A, product prices in column B, and order number for the products in
column C ... most products have more than once instance.. for example

product a 10.99 345353
product a 11.99 3445453
product a 10.99 657567
product a 8.99 345353
product a 10.99 5464646

so what I'm trying to do now is , when i type in the product
number(products
are alphanumeric w/ no spaces - the above is just an example) , I want
excel
to search for all entries matching the product entered (A1:A2000) .. If it
finds the products I would like it to display what order numbers are tied
to
that product number, maybe seprated by commas?

so if i put in D1 that i'm searching for 'PRODUCTA' it would return
something like this...

345353, 3445453, 657567, 345353, 5464646

showing me all the orders for which that product was used...

is this possible and if so, how?

Thanks alot guys!
Brandon Roland




.

Loading