+ Reply to Thread
Results 1 to 3 of 3

search for a name and then filter on it

  1. #1
    Registered User
    Join Date
    08-05-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    search for a name and then filter on it

    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

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    re: search for a name and then filter on it

    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.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: search for a name and then filter on it

    Something like his may do it
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1