+ Reply to Thread
Results 1 to 4 of 4

Auto refresh Auto filter excluding Zeros after chagnig date everytime

  1. #1
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Auto refresh Auto filter excluding Zeros after chagnig date everytime

    Hi,

    I have data in two sheets namely Master data and final data. In final data sheet, you can get the data as per datewise by changing the date you want in Cell E1.

    You can get the data by unselecting the zeros in filter E4. But whenever i change the date in cell E1, i need to get the data in the same sheet excluding zero automatically instaed of unselecting the zero every time. Is there any macro that can fulfill this? please help.

    Attached the data for ur ref.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Auto refresh Auto filter excluding Zeros after chagnig date everytime

    Try this out on the Worksheet Module -

    Please Login or Register  to view this content.
    See the file attached.
    Attached Files Attached Files
    Cheers!
    Deep Dave

  3. #3
    Forum Contributor
    Join Date
    10-16-2010
    Location
    bangalore
    MS-Off Ver
    Excel 2019
    Posts
    288

    Re: Auto refresh Auto filter excluding Zeros after chagnig date everytime

    it works well...thanks a lot.

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Auto refresh Auto filter excluding Zeros after chagnig date everytime

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Auto refresh and auto filter
    By andrugrasu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2015, 06:49 AM
  2. [SOLVED] refresh auto filter
    By jenn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. [SOLVED] refresh auto filter
    By jenn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. refresh auto filter
    By CLR in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 06:05 AM
  5. [SOLVED] refresh auto filter
    By jenn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. [SOLVED] refresh auto filter
    By jenn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. refresh auto filter
    By jenn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-19-2005, 08:05 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