Lookup Find Goto and SHOW
 

I have a lis of data on customers. I have customer SS #'s in column N. I
would like to create a macro that will find out if any one SS # is in the
list and then go to that row. Right now I use a macro with a helper cell to
show if the number is in the list or not:
Range("N9:N5000").AdvancedFilter Action:=xlFilterCopy,
CriteriaRange:=Range _

How do I get the macro to "Goto" the row that has the data in it?

Muchas Appreciatos - Thanks