In a sheet X the user has a cell (J5). The user put there a text. The user would like from the macro to find this text from (J5) in a column B of sheet Y (max 1000 rows to check) and if it finds the right row it copys columns (I:V) of the finded row and pastes it (just values) starting with a row 8 to the columns (B:O) in sheet Y. Macro should give back all the rows with J5.
vcoolio has assumed that you have headings in Row7 of SheetX.
Obtained from the OzGrid Help Forum.
Solution provided by vcoolio.
|How to find account number and add text|
|How to find a piece of text inside cells in a range and insert a line break on its left|
|How to find/return first nonblank value in adjacent cell from column with duplicate values|
|How to use VBA code to find and collect|