+ Reply to Thread
Results 1 to 7 of 7

advanced filter

  1. #1
    Registered User
    Join Date
    05-05-2009
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    38

    advanced filter

    Hi

    Anyone have experience with advance filters?


    I have a table range M53: Q99
    In this table values are imported from another sheet through VBA code

    Later on the same sheet have another table with the range A53: I72


    When the data is imported has a description in column M, a value in column N, another value in column Q and other in column Q

    Eg:

    M53: Demolitions
    N53: 1000
    P53: 10
    Q53: 2



    It turns out that there column N have the value zero because there is no value available from the other sheet.

    What was meant was based on the column N filter to exclude the data with zero and copy the data for table 2
    as follows:

    M53 goes to the A53
    N53 passes for F53
    O53 passes to the D53





    Is there an easier and fast way do this? I appreciate your views.


    Thanks in advance
    Attached Images Attached Images

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: advance filter

    you'll get better help if you post a workbook rather than a picture, I suspect.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    05-05-2009
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: advance filter

    Quote Originally Posted by romperstomper View Post
    you'll get better help if you post a workbook rather than a picture, I suspect.

    Thanks for the quick intervention!
    sending file example
    Attached Files Attached Files
    Last edited by jmaocubo; 05-26-2010 at 09:44 AM.

  4. #4
    Registered User
    Join Date
    05-05-2009
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: advance filter

    Quote Originally Posted by jmaocubo View Post
    Thanks for the quick intervention!
    sending file example
    It could do with a loop (if statement)?

    how?

  5. #5
    Registered User
    Join Date
    05-05-2009
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: advanced filter

    anyone????

  6. #6
    Registered User
    Join Date
    05-05-2009
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: advanced filter

    I apologize for being to insist .... but does anyone could help me?

  7. #7
    Forum Contributor trucker10's Avatar
    Join Date
    07-22-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003 / 2007 / 2010 prof +
    Posts
    149

    Re: advanced filter

    advance filters , see file example ( not yours )
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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