I have a report I am trying to assign per deal in VBA as "excess" or as "liability" in Column X based on a value in Column S:
If cell in column S is > 99.99 then it equals "EXCESS" in Column X
If cell in Column S is < 99.99 then it equals "LIABILITY" in Column X

The thing I am struggling with is assigning the value in Column X from Column S starting at cell S11 since that is where the values start. The header starts at cell S10 so anything below that with value applies.

Let me know if you can help!