Hide/Unhide Row based on dropdown value

[blaqoutent23]

Hi all,

I'm extremely new to VBA and need assistance.
I have 2 worksheets;
Worksheet 1 has is a list of all employees in both department "A" & "B".
Worksheet 2 is a list of employees from department "A" & their tasks for the day.

I would like to create a VBA where I can enter all of my employees from both department "A" & "B" in worksheet #1 and have a drop down list next to each name with "Yes" / "No" values to hide/unhide the row associated with that employee in worksheet #2 in case an employee is shifted from departments.

Hope this wasn't too confusing!

 

[ACommandLineKindaGuy]

I'm assuming that you are manually selecting the Yes and No values.
So assuming the Yes/No values are in column C and that you want to hide rows where column C says "No" you want to check all the rows in the used portion of the sheet, you could have a sub that does the following:

For Each c In Range(Cells(1, 3), Cells(UsedRange.Rows.Count, 3))
    c.EntireRow.Hidden = (c.Value = "No")
Next