Hi, I have a text file with following format and would like truncate section by section (Data1,Data2,Data3...) by searching start and end key words and then post to different new worksheet.

date/time <Action>START<Action>
date/time Data1...
.......................
date/time <Data>End<Data>

date/time <Action>START<Action>
date/time Data2...
......................
date/time <Data>End<Data>

date/time <Action>START<Action>
date/time Data3...
......................
date/time <Data>End<Data>

........


any detail inputs on VBA code. thx