Copy data (text) from a list on 1 sheet to another

[Lyng8]

I know this question has been asked before, but I need to ask again. Can't find it by searching posts.
I have a list of "members" names on 1 sheet and I need to be able to bring them up on another worksheet.
The surname is listed separately to the Given Name and I need to bring both up, by searching for the surname and given name at the same time.

I can copy data into another worksheet OK but not text, in 2 columns.
Does anyone have any ideas?
Thanks.

[simeon.hruby]

Hey,

This might help solve your problem. I built this search after watching a youtube video http://www.youtube.com/watch?v=Tr8Rwh8h1xM .

You should be able to search for the Name of A person or even a single letter in thier name (case sensitive) and it will return a list according to relevancy. Just input your list into the DATA tab. You might also need to extend the formulas past 50 rows if your list is longer. They are listed in Columns A & B of the DATA Sheet and Columns B & C on the SEARCH Sheet.

Hope this helps!


Simeon