Re: Filter and display rows on another worksheet

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Alan Beban (unavailable_at_no.com)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 14:33:26 -0700

The function I mentioned in the other thread you started on this same
topic can be used that way.

Alan Beban

JML wrote:

> Thanks Frank,
>
> Is there a way to automate the "Advanced Filter" to work like a function? I want to be able to enter the criteria in a cell and have the filter automatically calculate all of the time.
>
> Thanks
>
> "Frank Kabel" wrote:
>
>
>>Hi
>>sorry, my fault. Try using 'Data - Filter - Advanced Filter for this or
>>have a look at:
>>http://www.rondebruin.nl/copy5.htm
>>
>>--
>>Regards
>>Frank Kabel
>>Frankfurt, Germany
>>
>>
>>JML wrote:
>>
>>>Thanks Frank,
>>>
>>>The issue is that I don't want to summarize any of the data, but the
>>>data area of the pivot table forces me to summarize (count, add,
>>>etc.) the data. I want all of the actual values for the criteria I
>>>specify to appear.
>>>
>>>Thanks
>>>
>>>"Frank Kabel" wrote:
>>>
>>>
>>>>Hi
>>>>use a pivot table for this. See:
>>>>http://www.cpearson.com/excel/pivots.htm
>>>>http://peltiertech.com/Excel/Pivots/pivotstart.htm
>>>>http://www.contextures.com/xlPivot02.html
>>>>http://www.ozgrid.com/Excel/excel-pivot-tables.htm
>>>>
>>>>
>>>>--
>>>>Regards
>>>>Frank Kabel
>>>>Frankfurt, Germany
>>>>
>>>>
>>>>jml@gwinc.net wrote:
>>>>
>>>>>Hello,
>>>>>
>>>>>I would like help filtering a range of data and displaying it on
>>>>>another work*** based on criteria listed in the 2nd work***.
>>>>>
>>>>>Ex. (Work*** #1)
>>>>> Column(A) Column(B)
>>>>>Row(1) Job# amount
>>>>>Row(2) 1001 1
>>>>>Row(3) 1002 2
>>>>>Row(4) 1002 3
>>>>>Row(5) 1001 4
>>>>>
>>>>>(Work*** #2) - This is the result I am looking for.
>>>>>
>>>>> Column(A) Column(B)
>>>>>Row(1) Criteria= 1001
>>>>>Row(2) job# amount
>>>>>Row(3) 1001 1
>>>>>Row(4) 1001 4
>>>>>
>>>>>Thanks in advance for the help!!
>>>>>
>>>>>Josh
>>
>>

Quantcast