Starting in row of E4 of active tab, check and do the following:
using green = Interior.Color = 5296274
using yellow = ColorIndex = 6
using red = Interior.ColorIndex = 3
1. If yellow leave the row alone and move to the next row down E5 and check that.
2. If blank leave alone, (there can be multiple blanks in a row),
a. Look for next value in column E to check
b. If none there Exit Sub.
3. If cell in column E is green, and the cell in the same row (Column AJ) is blank.
a. Copy column C thru I of that row, to AG out.
b. If column AJ is not blank.. move to the next row to check in column E.