I have also come across this piece of code which does exactly what I want, however, there's a flaw as you can see other departments data if you simply write the department name in the disabled cell.

https://www.myonlinetraininghub.com/...able-filtering

Is there any way around this?