Macro to Find Matching text in a cell and select a specif cell

I have a client list in a table in my excel sheet. I currently enter the clients in a sheet that looks similar to a form. After the clients info is in this Form I have a button with a macro to copy the client info into a table on another sheet. This works perfectly.

Now I have another form that will retrieve the customers info in a click of a button in order to make changes to the client. Ei:I now have a second phone number and I want to update that client's info. What I want to do from here is take the info in Cell B2 (clients full Name), Do a vLookup in the "Saved Clients Table" in a Range within my table range. (Range: Saved Clients and the client's full name is in $A:$A and called "Clients Full Name" and once that name is found I need to select the cell in column C and the corresponding row.

This will allow me to copy the info in my form, Paste it in Transpose to the cell that is selected. (I already have that code)

Here are screenshots of what I am trying to accomplish.

https://www.dropbox.com/s/qrhoo6y3rz...ent%20Form.PNG

https://www.dropbox.com/s/1l5afn03te...d%20Client.PNG

Any help is appreciated.

Hy Carlonsdesk

Can you give us your workbook without private information ?

There is a lot of other sensitive things about the company in it and I cannot share it.

May I suggest:

Copy the file, change the data w/made-up info (Jack Doe, John Doe, Jane Doe, Tina Doe, 555-1234, 555-2345, 555-5678, etc.) and submit that. You shouldn't need a full complete file (maybe 8 entries) to get your point across.