+ Reply to Thread
Results 1 to 6 of 6

Macro select data with automatic filter

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Macro select data with automatic filter

    Hello to all.
    In the attached workbook is this possible with a macro?

    I select the range > Macros > msgbox = 18 > ok

    (18 = example)

    max_max
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,522

    Re: Macro select data with automatic filter

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: Macro select data with automatic filter

    Hello to all.
    This macro not found the date:

    Please Login or Register  to view this content.
    max_max

  4. #4
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: Macro select data with automatic filter

    Hello,
    you can add a new criteria to also search the dates here.

    c = Range("A2")
    c = c & "*"
    c = "*" & c & "*"

    I am attaching the workbook.
    max_max
    Attached Files Attached Files

  5. #5
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: Macro select data with automatic filter

    Hello to all,
    maybe I explained bad editing is not possible?
    max_max

  6. #6
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: Macro select data with automatic filter

    Hello macro with format cells text or number works, but not with the format cells = dates (years), help to correct?
    max_max

+ 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] Need automatic macro that makes 4 sheets disappear if a sheet outside of those 4 is select
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-18-2016, 02:26 PM
  2. [SOLVED] Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank
    By vinaynaran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2016, 08:47 AM
  3. [SOLVED] Macro to Select row as per filter
    By 13lack13lade in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2013, 11:49 PM
  4. Automatic filter and transfer data on other workbook
    By vintan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-16-2013, 03:59 AM
  5. Macro to NOT select certain items from a filter.
    By aadeshgandhi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2013, 02:04 PM
  6. Automatic custom filter on dynamic data
    By Seler Naciowy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-27-2008, 06:44 AM
  7. Automatic Filter Macro
    By Maxjohnson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2006, 10:31 PM

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