| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter/Advanced Filter
Hi All,
How many criteria I can Use in a Filter/Advanced Filter. for Eg. If i want to use six Criteria A=Ab, B=xy, C=gh, D=nd, E=cz F=bc how can I do this using Code? TIa Soniya |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter/Advanced Filter
Hi Soniya
Do you want to filter the six Criteria in the same column -- Regards Ron de Bruin http://www.rondebruin.nl "Soniya" wrote in message ... Hi All, How many criteria I can Use in a Filter/Advanced Filter. for Eg. If i want to use six Criteria A=Ab, B=xy, C=gh, D=nd, E=cz F=bc how can I do this using Code? TIa Soniya |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter/Advanced Filter
Hi Ron,
Different Columns Thanks -----Original Message----- Hi Soniya Do you want to filter the six Criteria in the same column -- Regards Ron de Bruin http://www.rondebruin.nl "Soniya" wrote in message ... Hi All, How many criteria I can Use in a Filter/Advanced Filter. for Eg. If i want to use six Criteria A=Ab, B=xy, C=gh, D=nd, E=cz F=bc how can I do this using Code? TIa Soniya . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter/Advanced Filter
Hi
Do you want to do it manual or with code ? Manual : With your data in A5:F30 for example Copy the header cells in A1:F1 Below each header enter your criteria Use this criteria range then A1:F2 in Dataadvanced filter If you want a code example post back -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... Hi Ron, Different Columns Thanks -----Original Message----- Hi Soniya Do you want to filter the six Criteria in the same column -- Regards Ron de Bruin http://www.rondebruin.nl "Soniya" wrote in message ... Hi All, How many criteria I can Use in a Filter/Advanced Filter. for Eg. If i want to use six Criteria A=Ab, B=xy, C=gh, D=nd, E=cz F=bc how can I do this using Code? TIa Soniya . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter/Advanced Filter
With code try this
Enter the headers and criteria in this range first Range("A1:F2") Sub test() Dim CriteriaRng As Range Dim rng As Range Set rng = Range("A5:F30") ' first row is the header row Set CriteriaRng = Range("A1:F2") rng.AdvancedFilter Action:=xlFilterInPlace, _ CriteriaRange:=CriteriaRng, Unique:=False End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Do you want to do it manual or with code ? Manual : With your data in A5:F30 for example Copy the header cells in A1:F1 Below each header enter your criteria Use this criteria range then A1:F2 in Dataadvanced filter If you want a code example post back -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ... Hi Ron, Different Columns Thanks -----Original Message----- Hi Soniya Do you want to filter the six Criteria in the same column -- Regards Ron de Bruin http://www.rondebruin.nl "Soniya" wrote in message ... Hi All, How many criteria I can Use in a Filter/Advanced Filter. for Eg. If i want to use six Criteria A=Ab, B=xy, C=gh, D=nd, E=cz F=bc how can I do this using Code? TIa Soniya . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
| Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
| How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Hybrid Mode
