VB Contact Search (Find, Copy and paste) Excel 2007

[Excelnoub]

Good day everyone,
I was fortunate to have some help on building this code and now I am trying to figure out why a new code is not working.
I have the following code in a macro

Please Login or Register  to view this content.

This is searching in my Column A (Sheet2) starting at A5 then when finding the information it copies itself to my sheet1 in C3.

I need a Cmd button3 to search for the information in Column “B5: B” and when it gets this info, to copy the matching row (A to F) the same way it is doing for my previous code, in C3 while transposing the info.

What do I need to change to make this happend?

[JBeaucaire]

Like so:

Please Login or Register  to view this content.

[Excelnoub]

Pure genious…Thank man

[JBeaucaire]

I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.

[Excelnoub]

Thank you for making this Solved