Copy & paste entire row to different sheet based on cell entry

Hello,

I have a sheet (Sheet1) with several hundred rows.
Column A is part numbers, columns B - J contain data regarding the part number. Due to a request, I need to setup a second sheet (Sheet2) in which a user can type the part number into a cell, lets say A1, and the macro would search Sheet1 - column A for the part number and then copy & paste that part number's entire row onto Sheet2, row 3.

Since a majority of cells contain hyperlinks a simple Vlookup won't work. And wrapping the Vlookup in the HYPERLINK function still doesn't retain the hyperlink.
So my thought is to use a macro that will copy & paste rather than just displaying the cell's text. Maybe there is a easier way to handle this without the use of a macro, but I am lost.

I appreciate anyone's help!

Hello,

Alansidman - I attached a quick example of what I am needing. A working example would help out great, Thnx.

Ragnaros - I tried your code, it wouldn't paste the row though. I will try again. I know enough VB to be dangerous so more than likely it was something I did incorrectly.

The search value is A9 and the code copies in to B9 and below.

It doesn't seem to work.
When I start typing into A9 it moves my cursor immediately to B9.

Both of the solutions work. Expecially mine. :p

You really need to go through a VBA tutorial and learn a little bit more on your own.

When I start typing into A9 it moves my cursor immediately to B9.
Which code are you referring to?
I have now added a button. When You enter a value in A9, the code first clears the existing data and repopulate the new data.
To prove the code works, I have change the value of some of the columns and see the result.