Macro to find a word and select a range based in their position

[jongova]

I have a format that is 62 rows by 11 columns and in the same sheet and are placed one above the other. Each format has an identifier like "Eco 2" and their position in in the first column, row number 4 of each format.

I want a macro that find for example "Eco 4". If the Eco 4 are in the cell A314 the macro should select the range A311:K372, then copy and paste in other workbook, each format in different sheet of the new workbook. Is possible that I can found Eco 4 more than one time in the original workbook.

I want consolidate all Eco 4 formats in a new worbook in differents sheets.


Thanks experts.

In the attached file the identifier is "Pozo: XXXX" try searching CAFETO-20 (DES)