Searching for a match in a column then copying whole row

Budget 136$ per month

Posted: 4 year ago

Opened

Description: Basically I would like to enter a string in a specific cell in Worksheet A and a macro searches in the first column in Worksheet B to find all matches. Every time a match is found the whole row is copied (including formatting) and pasted in Worksheet A. When the macro runs it will clear any previous matches displayed in WorksheetA and replace them with the new matches.

Detail about the workbooks
'WorksheetA(Results)': Contains the specific cell to enter string (cell A1), and displays the copied rows from (row A10 onwards)
'WorksheetB(Data)': Contains 50 rows of data, each row is 7 columns. So lets say the range(?) is from A1:G50.

Thanks

Frank
Skills:
software development,Visual Basic programming language,workbook

Source: peopleperhour.com