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!