ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,596
- Office Version
- 2007
- Platform
- Windows
I’m looking to find matching values “customers names” in one column.
This column being column A
I can’t use a code where the user would manually enter a customers name as that would take far to long.
The code needs to decipher the names in column A itself.
The code would only need to be interested in customers names that match & have appeared more than once.
The names are saved like so.
TOM JONES 001
BOB SMITH 003
The code would need to ignore the 001 002 003 etc etc part & concentrate on the name.
Maybe best to put these names in a listbox along with its row number ??
What do you think, any advice welcome please.
Thanks.
This column being column A
I can’t use a code where the user would manually enter a customers name as that would take far to long.
The code needs to decipher the names in column A itself.
The code would only need to be interested in customers names that match & have appeared more than once.
The names are saved like so.
TOM JONES 001
BOB SMITH 003
The code would need to ignore the 001 002 003 etc etc part & concentrate on the name.
Maybe best to put these names in a listbox along with its row number ??
What do you think, any advice welcome please.
Thanks.