Quote Originally Posted by Excel Fox View Post
Hi - not sure how the output was decided. Could you explain each of the three cases.

I want to copy and paste the lines between Keywrod1 and Keyword2 from sheet1 to a new cell/row in sheet2 in all cases.
Keywrod1 and Keyword2 appear hundreds of times in the original data and data rows are there between the keywords.