Hi there,

I need to hide specific rows in worksheet 1 based on 2 variable cells in worksheet 2.

I.e. i need to automatically hide rows in worksheet 1 based on "Area" and "Role" that would be updated in a drop down list dependent on the user in worksheet 2. The rows in worksheet 1 contain both Area and Role information.

Any help on how to do this would be much appreciated.