Thread: Hide Rows based on Client Drop Down List

Hello All-

I am a horrible newbie. I have a Data Validation dropdown list of clients in a time sheet. Then I have 5 sections for weeks of time entry.

Row Ranges for Time Entry:

9:29
33:54
58:79
83:104
108:129

Within these ranges, column C has the client name that matches the dropdown selection.

What I want is to select a client from the dropdown, and hide all other rows...so I can print a time sheet for hours billed to the selected client.

If I choose "none" from the drop down...the all rows should be visible.

Where do I begin?

Thank you!

Troy

Todd,

I think I can help if you can clarify a couple of items.

So, I don't see a validated list anywhere in the spreadsheet Where will this master client list drop down occur? Next to the Filter cell (Cell J4)?

Hi AlvaroSiza-

Yes, I have the drop down in J4. Not sure why it isn't showing up, I thought it was there when I uploaded it.

Thank you in advance, I am super excited to see what you come up with.

And it's my birthday today! So even better!

Troy