Hi all,

I am seeking a method of collecting data from one sheet in a workbook and displaying it on another, based on a search.

e.g.

Sheet1
Garcia Joe 11111
Garcia Matt 22222
Hernandez Efrain 33333
Matias Jorge 44444

What I want to do is to have Sheet2 be a query for Sheet1--that is, in a cell in Sheet2, the user can type 'Garcia' into a cell and thus display the matching entries from Sheet1, e.g.

Sheet2
'Garcia' displays

Garcia Joe 11111
Garcia Matt 22222

I don't know if this can be done purely within Excel or if I'll need a VB macro to do it, any help would be greatly appreciated.