This *almost* works, but for two issues I am trying to solve. 1) for whatever reason, the code is not recognizing "Life Sciences" as a defined category. 2) For whatever range is selected for an undefined category, it should include the category heading, and not just the data. So close...

If I run the updated code on

OrganizationDate
2 Data row
3 Data row
4 Data row
Undefined category
6 Data row
7 Data row
8 Data row
Life Sciences
10 Data row
11 Data row
12 Data row
Undefined category
6 Data row
7 Data row
8 Data row


I am left with

OrganizationDate
2 Data row
3 Data row
4 Data row
Life Sciences
10 Data row
11 Data row
12 Data row

So for point 1 check the spelling of the Life Sciences category in your document matches that in the KeyTerms string (and that includes the number of spaces between the two words)

For 2 I can't reproduce what I think you are saying in that you are getting

OrganizationDate
2 Data row
3 Data row
4 Data row
Undefined category
Life Sciences
10 Data row
11 Data row
12 Data row
Undefined category


Which I don't.