PDA

View Full Version : [SOLVED] Advanced locked Filtering data



alinac
12-20-2020, 08:41 PM
Hello Team,

In a particular delivery management excel sheet I need to assign a macro to a button that will filter the data, excluding old data as below.

For example, the current month is December, I need to populate data in the file for the previous month, November, that is already closed, but I need people not to be able to see the data for October, September, 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 mw with this?

Thank you!