I have a spreadsheet which has data in the following format
I would like code which looks through each of these rows, if it contains the word "love" then extract that set of file.![]()
FILE_STARTxxxxxxxxx 111moneyistheking money joker 12312342453534 123monkey love packages FILE_STARTxXxxXaidoa 4564543love 666pokerking 888love FILE_START1231231 445joker FILE_START6666 4848864
a file starts with the word "FILE_START" and ends when the next "FILE_START" is present. So the "extract" must contain all rows inbetween the two "FILE_START"s if the word "love" exists in between the two "FILE_START"s...
The number of rows in between each "FILE_START" can vary.
so with the above data in say sheet1, i would like to following output in sheet2
I hope this makes sense?![]()
FILE_STARTxxxxxxxxx 111moneyistheking money joker 12312342453534 123monkey love packages FILE_STARTxXxxXaidoa 4564543love 666pokerking 888love
Bookmarks