+ Reply to Thread
Results 1 to 4 of 4

Macro - AutoFilter and crietria

  1. #1
    Registered User
    Join Date
    08-07-2014
    Location
    Prague
    MS-Off Ver
    2007
    Posts
    3

    Macro - AutoFilter and crietria

    My problem is following: I have a list of data that are classified according to a particular character, and I want to copy (with auto filter through the macro) the relevant information to the appropriate place in the sheet where it belongs. Thatīs no problem. The problem is that if I want to copy data, classified by a character that is not listed in the table (that is not in the filtering criteria), then all the data are copied to the appropriate place. But I do not want to copy in this case nothing. How should such a macro look like? Thank you for your advice. Please find attached an example.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Macro - AutoFilter and crietria

    I ran the macro. the macro is ok. even now it does not give any fill in in column I except the word Name in I3.
    but there is minimal automation. the macro can be tweaked. I have removed the word name from G3 to I3.

    I have prepared a new macro called "test"

    try this and see whether you get what you want.confirm. if there is doubt revert to newsgroup

    Please Login or Register  to view this content.
    Last edited by venkat1926; 08-09-2014 at 03:53 AM.
    I am not an expert. better solutions may be available
    [email protected]

  3. #3
    Registered User
    Join Date
    08-07-2014
    Location
    Prague
    MS-Off Ver
    2007
    Posts
    3

    Re: Macro - AutoFilter and crietria

    Many thanks for the help, it works but I have one more request. Could you describe your macro in more detail (in words)? I do not understand some of the lines of this macro in the sense of functioning. I would like to apply this issue to more complex procedures. Thank you.

  4. #4
    Registered User
    Join Date
    08-07-2014
    Location
    Prague
    MS-Off Ver
    2007
    Posts
    3

    Re: Macro - AutoFilter and crietria

    And I found out that this row:............... rc.AdvancedFilter xlFilterCopy, , unqcode, True.............. does not work. Where is the problem?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Autofilter Macro Failing - Run-time error 91 - full macro code is attached
    By evamarie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2013, 02:36 PM
  2. Control autofilter in macro and continue macro
    By robdo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2012, 01:51 PM
  3. [SOLVED] Autofilter macro once runned, stop and run another macro
    By streamofmight in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2012, 07:08 AM
  4. Copy data on crietria
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-25-2012, 03:37 AM
  5. COUNTIF multiple crietria
    By Karol Satka in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-11-2006, 08:40 PM

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