+ Reply to Thread
Results 1 to 5 of 5

Recording advanced filtering macro

  1. #1
    Registered User
    Join Date
    08-08-2014
    Location
    Here and There
    MS-Off Ver
    2010
    Posts
    25

    Recording advanced filtering macro

    Hi guys,
    I have report with new data every day. every day I am filtering it to different sheets in order to be able to work with it.
    I want to make a template using VBA, that will allow me to enter new data every day and just click a button which will sort it the way I need.

    I tried to use advanced filtering and recording it. Once recorded I added a button on the first sheet and assigned it to the recorded macro.

    However, when I click the button (without even changing the data- it is still the same data that was recorded), I get the following error:

    Run-time error '1004':
    The extract range has a missing or illegal field name

    I know it is an error that the advanced filtering gives when I have a problem with the range to where I want to copy. But I don't understand why I get this error.
    Attaching my attempt.

    Thanks,
    Niuk
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Recording advanced filtering macro

    can you please explain what you are trying to achieve with your code?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Recording advanced filtering macro

    ok i figured out what you were trying to do

    you were missing sheet names

    Try this code


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by humdingaling; 09-02-2014 at 03:42 AM.

  4. #4
    Registered User
    Join Date
    08-08-2014
    Location
    Here and There
    MS-Off Ver
    2010
    Posts
    25

    Re: Recording advanced filtering macro

    Hi,
    I want to take all data on the second sheet (called "copy all data") and filter it to few separate sheets:
    On the third sheet ("close") I want it filtered by the "Filter ED" column- only "close" values.
    On the forth sheet ("Yellow") I want to filter by 2 columns: "Filter" column (value yellow) and "Filter ED" column (value open) etc.
    I am attaching the filtered report (the result I want the code to do).
    Thanks

  5. #5
    Registered User
    Join Date
    08-08-2014
    Location
    Here and There
    MS-Off Ver
    2010
    Posts
    25

    Re: Recording advanced filtering macro

    and the file
    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)

Similar Threads

  1. [SOLVED] Advanced Filtering Macro takes out the existing filter
    By sachins19 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-21-2014, 09:25 AM
  2. [SOLVED] Easy filtering method via vba/formula/advanced filtering?
    By jedemeyer1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2014, 12:35 AM
  3. More advanced advanced filtering
    By Acceleracer in forum Excel General
    Replies: 2
    Last Post: 02-06-2014, 09:02 PM
  4. Advanced Filtering by Date (or Macro) Help
    By Alexis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-08-2006, 01:15 PM
  5. Macro to perform Advanced Filtering
    By Spencer Hutton in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2005, 09:07 AM

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