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
Bookmarks