Automatic Filtering by some specific value

[Tiera1]

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!

 

[AlanSidman]

crossposted:
http://www.vbaexpress.com/forum/show...specific-value
http://www.vbaexpress.com/forum/show...specific-value
https://www.mrexcel.com/board/thread...value.1156584/
https://www.myonlinetraininghub.com/...c-value#p18083
https://www.ozgrid.com/forum/index.p...pecific-value/

Filtering by some specific value

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

www.excelforum.com

 

[vletm]

Tiera1
As a new member, You really should reread Forum Rules ( here as well as from other forums).

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org