December 22, 2020
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?
December 20, 2019
i have created a small macro to filter out anything older than the 1st of the previous month and attached it to your button, but if you really dont want any user to see the old data but be allowed to enter new data i would suggest an input page or input form - otherwise it could get very messy with locked cells etc