Given is a excel file (see attached file as a sample) with 2 sheets. Sheet one is a overview sheet with projects and customers. sheet two has details to the projects and customer. what I need is a flexible way to give the user an easy way of handling the autofiltering. I think of an easy click to the customer, then excel should swith to sheet two, select the customer as clicked before and show so only the details of this. Same with Project. If user clicks to the coordinate of customer/project both fields should be filtered. The solution should be flexible enough to let the sheet one easily extend by new customers, projects. And also remove customer / projects.

## Deliverables

Full functional and documented VBA code.


## Platform

Excel 2000 VBA