Create a Search Macro

[nzepeda]

I need to create a Macro that take the first 6 letters from Sheet1 A1 and Search Sheet2 along Column A for any matches.

After it finds all the matches, I will need it to display the matches to the user. When it displays to the user I would like it to display the cell it found and 1 over to the user with a checkbox. After the user checks which is the correct 1, it will need to copy those 2 cell values to Sheet1 C1.

Any Help would be appreciated.

I am getting stuck with the Search part of this macro.