How to recover data in VBA EXCEL

[PAOLA]

I have to recover data by typing a date. Typing a date in a cell I would like the customer list that is in another sheet if they have displayed in their information (date of contract) corresponds to the date by typing user.

[Maceo]

How many customers? how many possible dates?

[PAOLA]

There are hundreds of customers around and they do not all have the same date of the contract.

[Fanchon]

You can use an array formula for displaying the list. but there should be an example (without confidential information) for the structure. This will simplify the creation of formulas