Method of retriving specific data from a worksheet

[William]

Dear All,

I have a worksheet with many many rows. Did anyone know how to retrieve
specific data out and placed on another cell.

Example:

Column1 Column 2 Column 3 Column 4
Row1 David Man 30 50
Row2 William Man 5 4
Row3 David Man 5 20
Row4 Andy Woman 20 20
....

Outcome Result:
RowA David Man 30 50
RowB David Man 5 20


I want to retrive specific data with matching a word, David, out and placed
the information to a new cell. At that moment, I use Find from menu and
input the word David and click find. After goto the specific word, I copy
the information out and paste on a new cell. This is useful in a few rows.
However, I have many many rows. Did anyone know how can easily retrieve
data out?

Thank all friend,
William Chan

 

[PY & Associates]

Try Data/Filter/Advance filter, copy to other location