+ Reply to Thread
Results 1 to 5 of 5

Auto Filter search and then remove search data to allow a new search

  1. #1
    Registered User
    Join Date
    11-06-2014
    Location
    Australia
    MS-Off Ver
    15.0.4659.1001
    Posts
    6

    Auto Filter search and then remove search data to allow a new search

    Hi,
    I am trying to auto filter a list (sheet1) and summarise it on Sheet2 with a macro button. The next stage I am having problems with as when I do another search (filter) the new list overfills the last list. If it is smaller result, part of the previous list is visible. Can I add to the macro so that when the button is clicked it erases all data below the start input cell and then adds the new filtered list?

    I have attached a test file.

    Cheers
    John


    Test List.xlsm

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,277

    Re: Auto Filter search and then remove search data to allow a new search

    Try this:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-06-2014
    Location
    Australia
    MS-Off Ver
    15.0.4659.1001
    Posts
    6

    Re: Auto Filter search and then remove search data to allow a new search

    Thanks Alan,

    This works well but it would be better if it deletes the rows as if the new list is smaller than the previous one it still leaves any filled coloured rows there and borders etc. Is there a way to delete the previous rows?
    Cheers
    John

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,277

    Re: Auto Filter search and then remove search data to allow a new search

    Try this instead:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-06-2014
    Location
    Australia
    MS-Off Ver
    15.0.4659.1001
    Posts
    6

    Re: Auto Filter search and then remove search data to allow a new search

    Thanks Alan.

    This works a treat. Great work and thank you.

    Cheers
    John

+ 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. VBA Code - Search text & search number & search qty and result - Urgent Please
    By naresh73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2014, 10:51 AM
  2. [SOLVED] userform search button remove search only when i type
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-08-2014, 02:32 AM
  3. [SOLVED] Macro/s to create Search Bar to filter to search terms entered activated by Command Button
    By JasonRay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2013, 03:44 PM
  4. [SOLVED] Match search terms, and add data in next column. Multi search problem.
    By Wales MB in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-23-2013, 06:10 PM
  5. [SOLVED] auto filter doesn't return cells containing the custom search wor.
    By annelidae in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-23-2006, 12:25 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