Results 1 to 5 of 5

Recording advanced filtering macro

Threaded View

  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

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. [SOLVED] 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