| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Go to goto - FIND | Excel Discussion (Misc queries) | |||
| On error from Find, GoTo E | Excel Discussion (Misc queries) | |||
| Goto or Find a Date in a Sheet | Excel Discussion (Misc queries) | |||
| find the last Fred and goto cell | Excel Worksheet Functions | |||
| LOOKUP: dbl-clic results returned to GoTo? | Excel Discussion (Misc queries) | |||
Linear Mode
