Match specific rows with a column

[topi1]

I would like excel macro for the following function if someone could please help. Thank you.

1) Finds rows containing "TITLE1:" and "TITLE2:" in column R, sheet2.

2) Iterates through rows between "TITLE1:" and "TITLE2:" (excluding those two rows).

3) For each row, does the following.
i) Checks if column O, sheet2 is empty and column R, sheet2 doesn't contain ":". (Column R cell will contain other strings. Just checking if also happens to contain ":")
ii) Searches for a case-insensitive match in column A of "sheet1".
iii) If found, Concatenates columns B of sheet1 and R of sheet2, putting the result in column R of sheet2.
iv) No action if no match is found.

There will be intermittent empty rows in column R, sheet2.
Column A, sheet1 will have no blank cells. Although it will be nicer to allow blank cells but ONLY IF IT does not slow down the macro.

Thank you.

 

[Peter_SSs]

I think that you will be more likely to get some useful responses if your provided some smallish dummy sample data of both sheets and the expected outcome with XL2BB so helpers could easily copy and do some testing, knowing what the data & expected results are actually like.