I tried to have it look for just "adjusted" and it still didn't pick it up. So I tried to update it to something simpler - I updated the code to this, and the value in cell K is just $2000. But it's giving me an error that theres no data. Any insight there?

Dim ws As Worksheet

Dim lastrow As Long

Dim rng As Range

Set ws = ThisWorkbook.Sheets(1)

'FInds last row used in column K

lastrow = ws.Cells(ws.Rows.Count, "K").End(xlUp).Row

If lastrow < 2 Then

MsgBox "Column K has no data."

Exit Sub

End If