Newbie Looping: New Instances Of Symbol Values

I have a looping dilemma. I update daily stock information to a table. Column A is the symbol. There are repeats of the symbol, which is what I'm looking for to start running functions/ alerts on them based on criteria etc. Anyway. I'm trying to loop through to look for new instances of symbol values, or, values in column A. What I've tried to do so far experimentally is to get a symbol value to be counted from an input box, then find a matching value in the range. It's below, not working:

Sub NewSymbolAdd()

'This is the macro that will loop through the symbols column of the master list to see if the new data downloads are new/
'need to be set up to download daily pricing data or ignore if that sheet already exists.


Dim symb As String
Dim finalrow As Long
Dim count As Long
Dim countsymb As Long

'Find the range size.

Worksheets("Watch List Main").Activate
finalrow = Cells(Rows.count, 1).End(xlUp).Row.........