search for a name and then filter on it

**Migraine** · 08-05-2009, 02:39 PM

I am a noob and ask forgivness... I have search high and low, but to no avail i have not been able to find what I am looking for..

I have a report that comes in a few different formats... the headers are not always in the same spot ( I have no control over that). One report the column may be in A10 and another may be in Z7... etc

I am looking to build a macro that will find the column named "OVLP_TYPE_**" (without quotes). Once that column is found i need to filter on that column for the term "CNC" (without quotes). I can then use the rest of the code i made to copy paste the results to another worksheet

any help would be great and if more info is needed please let me know

-g

**royUK** · 08-05-2009, 03:12 PM

Welcome to the Forum. Please read the Forum Rules and you will see that your thread title should not contain unnecessary words like Excel & macro.

**royUK** · 08-05-2009, 03:28 PM

Something like his may do it

Code:

Option Explicit

Sub FindnFilter()
    Const sFind As String = "OVLP_TYPE_**"
    Const sCrit As String = "CNC"
    Dim Col    As Long

    On Error GoTo notfound
    With ActiveSheet.UsedRange
        Col = .Find(sFind, LookIn:=xlValues).Column
        Selection.AutoFilter Field:=Col, Criteria1:=sCrit
notfound:
        End With
        On Error GoTo 0
End Sub

Thread: search for a name and then filter on it

Thread Tools

Display

search for a name and then filter on it

re: search for a name and then filter on it

Re: search for a name and then filter on it

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions