find values between cells and paste in rows of another sheet

Hi friends,

Please help me to create script which copy values from one sheet and paste it to another sheet.

Input is like below :

START
M1
M2
M3
END
START
M4
M5
M6
M7
M8
END
START
M9
M10
END


Output required is below in another sheet.

M1 M2 M3
M4 M5 M6 M7 M8
M9 M10


i want to copy values in betn start to end values and paste that values in one row respectively.

Thanks in advance

Try this:

Please Login or Register  to view this content.

Thank you very much stephen,

Its working perfectly


teylyn sorry to post my query in wrong forum