Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced filter
How can I use advanced filter and have it returns only
data that match what is in a cell. I use a listbox and select a name, this name is referenced in the criteria cell but it returns all data that looks like the criteria. Can I reference a cell as a criteria in auto filter. I use Excel 2000 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced filter
In the criteria cell, use a formula similar to the following:
="="&L1 where the item selected in the listbox is linked to cell L1 ANDRE ANDERSON wrote: How can I use advanced filter and have it returns only data that match what is in a cell. I use a listbox and select a name, this name is referenced in the criteria cell but it returns all data that looks like the criteria. Can I reference a cell as a criteria in auto filter. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced filter
Thanks so much it worked just fine. I keep your name for future help if
you don't mind. I realize that some people did some ground work before me. What about the second question, if you indulge me? Can I reference a cell as a criteria in auto filter. Andre Anderson *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced filter
You can reference a worksheet cell in your AutoFilter code. For example:
ws.Range("A1").AutoFilter Field:=7, _ Criteria1:="=" & Range("K1").Value Andre Anderson wrote: Thanks so much it worked just fine. I keep your name for future help if you don't mind. I realize that some people did some ground work before me. What about the second question, if you indulge me? Can I reference a cell as a criteria in auto filter. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
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) |