Hello All,
I have a Workbook with 3 worksheets
Sheet1 called quote form
Sheet2 called Help
Sheet3 called Data

In Sheet1 I have the following information...
Cell A4 - To:    B4 Imnot Kim
Cell A5 - E-mail:     B5 "Populate"
Cell A6 - Phone:     B6 "Populate"
Cell A7 - Fax:         B7 "Populate"

in Sheet2 I have non related data to what I'm trying to accomplish

Sheet3 I have the following information...
Name    Contact  Tel    Fax    Email Address
Imnot Kim    Ron       905.123.4567    905.123.4567    123@4567.ca
Yournot Kim    Paul        416.123.4567    905.123.4568    123@4568.ca
Whose Kim    Sandy        604.123.4567    905.123.4569    123@4569.ca
Wheres Kim    Antonie        780.123.4567    905.123.4570    123@4570.ca
Hi Kim        Sheldon        403.123.4567    905.123.4571    123@4571.ca
By Kim        Rose        205.123.4567    905.123.4572    123@4572.ca

Here's my dilemma, when I type in Imnot Kim in cell B4 I would like Cell
B5-B7 to retrieve and populate the corresponding information from the data
sheet.

Once again Thnx,
Badrasta