I have a large table of data. In column B, are the names of people in the table formatted "Last name, First name." I have over 1,000 people in the table. At times, I get a list of 10-15 people to look up. Instead of scrolling through and finding the names, I'd like to use the autofilter already set.
I'm wondering- is there a macro where I could type in a name to the macro and it would automatically autofiler on the names typed in? I suppose I'd like an approximate match (no need to be exact). Also, some of the names I type might not yet be in the table so it'd have to account for this.
A lot of talented people on here, I have a feeling this can be done. If it can't, please let me know why as it will be a good learning experience.
I'm wondering- is there a macro where I could type in a name to the macro and it would automatically autofiler on the names typed in? I suppose I'd like an approximate match (no need to be exact). Also, some of the names I type might not yet be in the table so it'd have to account for this.
A lot of talented people on here, I have a feeling this can be done. If it can't, please let me know why as it will be a good learning experience.