VBA code to partial match and return all values

[MiltonSilva]

Hello,

I have a Sheet called "Customers" and column D has Customer Names.
In Sheet2 I want to search for Customer names and return all values that correspond to a partial match.
Let's say that I want to insert in cell Sheet2!A1 a string, click a "find button" and search in "Customers" sheet for a partial match and return in column Sheet2!B all the results.
Can anyone help me with this?

Tks in advance.

[Marc L]

Hi,

see an advanced filter …

[MiltonSilva]

Hi,

Tks for your reply but a filter won't be an option.

I guess I miss an important explanation: My point with this "returned" values is to pick one, put it on a cell that belongs to a table where I will fill with other info manually inserted (not in Costumer sheet).
With the next searched value I'll do the same and put it in the next row.