循环遍历行/列并检查值以确定要分配给新列的值

I've spent half day or so over this week learning vba, and building up this macro. After much research, mostly done on stackoverflow - this is what I have so far. I keep getting sub or function not defined when it compiles. It then highlights the world cell portion of the cell (i,"T"). I've spent half day or so over this week learni