Hide rows in range 2 based on filter selection in range 1

Hi Charles,

Thanks for coming back to me.

I can understand your thinking about the dates but this is not what I was after.

Have a look at v2 of the sample spreadsheet attached where I have written in what I want to happen (Option 1 or Option 2). If Option 1 is too messy, I would be happy to go with Option 2 - whatever is easiest to implement.

I just don't know how to approach the coding for doing either of these things. Any help here would be great.

Thanks Charles,


gtol