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
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?