VBA ms excel work

General information for the business: software
Kind of development: Customization of existing program
Description of requirements/functionality: hello we need a quick code fixed, VBA in ms excel, the macro must perform the filtering as following:

1. First criteria: search within a range to match a value selected in a cell + Second Criteria: search within another range the cells that match another selected.

2. Both cell selections are based on drop downs

3. BOTH criteria must be applied to the visible columns based on AND condition BOTH cells are used as the filters, meaning only the columns that MATCH BOTH conditions will be displayed.

We expect this to be a quick development of many other developments that are coming out.

thanks
Specific technologies required: VBA
Extra notes: hello we need a quick code fixed, VBA in ms excel, the macro must perform the filtering as following:

1. First criteria: search within a range to match a value selected in a cell + Second Criteria: search within another range the cells that match another selected.

2. Both cell selections are based on drop downs

3. BOTH criteria must be applied to the visible columns based on AND condition BOTH cells are used as the filters, meaning only the columns that MATCH BOTH conditions will be displayed.

We expect this to be a quick development of many other developments that are coming out.

thanks