Posts by Tiera1

    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 45 times, last: )