Yes, you've captured the essence of the problem (more or less). I want to identify instances of undefined categories, period. If it occurs like this:

1 Defined Category
2 Data Row
3 Data Row
4 Defined Category
5 Data Row
6 Data Row
7 Undefined Category
8 Data Row

Then I just want to copy everything in rows 7 - 8 (or the end of the document).

If it occurs like you presented it:

1 Defined category
2 Data row
3 Data row
4 Data row
5 Undefined category
6 Data row
7 Data row
8 Data row
9 Defined category
10 Data row
11 Data row
12 Data row

Then I want to select rows 5-8 and copy them.

Hope that helps, and thank you for taking the time to help me out