Thank you for your help. I am still getting the same error with Find code all yellow and the arrow pointing a the last line. Maybe it doesn't like the .Activate part?
I do need it to initially pull the Terminal # from my own selection in Sheet 1 as I have not tackled the looping function yet (the task I am accomplishing ultimately needs to be repeated for about 400 rows which is why I am writing this script). If the Active cell is stores first and then the script activates some other cell the string that was stored is untouched and not changed correct?
I tried changing the string reference in the Find function to actual "" text which IS present and I still got the error.
Lastly - for the blue ActiveCell part - I am only needing to search through column A in sheet2 so what can I put in the After spot for that?