Search for Substring within a String using loop

I have a very long spread sheet with tons of data. What I need to do is to search the spreadsheet using a loop func (or other better ideas) of Column1 until it finds a substring called STARTDATA1, and ends the loop until it finds a substring called ENDDATA1. And all the values inbetween the rows of STARTDATA1 and ENDDATA1, I need to parse values of column 3,5,7 onto another template. How should I write the code?

Hallet

Workbook 1.xlsx
So heres part of the worksheet,
I need to collect the values from "0/ BEGINDATA1" which should be row 1398, uptill "0/ ENDDATA1", which should be row 1547, So I need a loop that can detect the substrings,when it detects 0/ BEGINDATA1, it starts to take in the values of column 3,5,7 until the loop detects 0/ ENDDATA1, and parse all the data into another template

bump...
Anyone has any idea?

Copies Data from Active Sheet to Sheet 2
Column G was Blank in the example you uploaded.

Please Login or Register  to view this content.

yes, paste the values under column x,y,z of sheet2

Try This:

Please Login or Register  to view this content.