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