Lookup values in textbox and edit row
 

My previous post may have been confusing (at least to myself)

Basically I have 2 sheets "Edit" and "Data"

The "Data" sheet looks like this

Name Number Status
Mark 564 Active
John 231 Inactive
Bill 789 Active

If a user types John into a textbox("tbfindname") in the sheet "Edit" and
clicks a command button("CBFindName") I would like my 3 other text boxes
tbname, tbnumber and tbstatus to display John, 231, and Inactive.

After that if the user changes John's status to Active I would need another
command button that would change the "Data" sheet to reflect the change in
the textbox.

Name Number Status
Mark 564 Active
John 231 Active
Bill 789 Active

Please Help!