OK I think I have kind of figured out a much easier way. I've made another worksheet called 'Template (2)'. In putted all the text in their and then made an if statement via excel. Now all I want to tell VBA is: if a cell says "N/A" Then delete that row. I'm trying to use this formula but it isn't working.
If Worksheets("Template (2)").Cells("2:2") = "N/A" Then
Rows(1).Rows(2).Delete