Filtering
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Filtering

  1. #1
    Guest

    Default

     
    I have a large list of entries (>2500). I would like to be able to search a column for a particular reference number, say 04800-00. This number may appear by itself in a cell, or as part of a list of numbers in a cell. Is there a way to get a macro that will prompt me for a value, search for that value, and then only display those entries with that number (like a filter)?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Arizona
    Posts
    72
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You should be able to use the advanced autofilter command. Follow the rules Excel's help to use it. It's pretty cool since it hides the rows that you filter out.

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I ues advanced filtering on 35000 + rows. If you need any help, drop me a note.

    PJ

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com