Hello guys,

I'm building an excel workbook for someone who knows little about computers.

It is a sheet with a table where I have 'House number' and 'Things to do'. This is something I will put in. What the users has to do is to choose the 'House number' (with a drop down list) and then choose 'Things to do'. Then he/she has to add the 'Date' and write a comment on what he did specifically.

A simple Filter (Data - Filter in excel) is too complicated since there you get drop down menu instead of a simple drop down list

How can I make a table that works exactly like the Filter in excel but has a drop down list ?

Thank you so much for the help.

excel.JPG