Inserting text based on a predetermined criteria early in the macro

Which column would the title be in?

You could replace the .Value statement with:

.Value = c.offset(2,4).value

Which would look two rows down and four to the right (column H) for the title and place it in column A of the inserted row.