Lookup Find Goto and SHOW

T

Teddy-B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top