Automatic Filtering by some specific value

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    crossposted: mrexcel.com/board/threads/auto…e-specific-value.1156584/

    Hello Community,
    In a particular delivery management excel sheet I need to assign a macro to a button that will filter the data, excluding old data.
    In the current month of December, the team is adding data for November, but I don't want they to be allowed to see the data for Oct, Sept, Aug, etc.
    For this, I need to action a button that will hide the data for older than November, and the person who will manage the file would have to insert a password for both hiding and unhiding.
    Can someone help me with this pleaseeeee?

    Thank you!

    Files

    • Book2.xlsx

      (18.49 kB, downloaded 77 times, last: )
  • HI BRO,


    1, GO TO B6 COPY THIS FORMULA =IF(A6="","",IF(A6<=EOMONTH(TODAY(),-2),"NO","YES")) AND DRAG DOWN.

    2. SELECT A5:B5 AND GO TO DATA TAB MAKE FILTER AND IN B5 TIK YES ONLY.

    3. GO TO REVIEW TAB, CLICK PROTECT SHEET TIK PROTECT WORKSHEET AND CONTENTS OF LOCKED CELLS, TIK SELECT LOCKED CELLS, TIK SELECT UNLOCKED CELLS AND BAL ALL UNTIK AND GIVE OWN PASSWORD AND SAVE.


    REGARDS,

    DACKSON.