View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teddy-B Teddy-B is offline
external usenet poster
 
Posts: 76
Default 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