Results 1 to 4 of 4

Auto refresh Auto filter excluding Zeros after chagnig date everytime

Threaded View

  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

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. [SOLVED] refresh auto filter
    By CLR in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 06:05 AM
  5. refresh auto filter
    By jenn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. refresh auto filter
    By jenn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] 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