Search spreadsheet for text entered into cell and copy row of found text to new row.

Need to search spreadsheet for any text string entered into a set cell then have entire row copied to new row. If multiple rows are found then multiple rows need copied.

try this macro
it searches the used range of the active sheet for the contents of cell A1 and copies rows with the same text, starting at row 20
ou make want to tweak it to set the search range, target cell or output range

Please Login or Register  to view this content.