ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,227
- Office Version
- 2007
- Platform
- Windows
On my worksheet i enter customers in column A
Over time i get repeat buyers of which i cant have the same name in the cell so it needs to be followed by a number etc.
So here is the example in the screens hot supplied.
I would advice on how i can overcome this.
I think the best thing to do would be to show a msgbox with the latest number should it be a duplicate ?
Some info for you.
Column A is where the customers name are.
The range will always be A6 then down the page.
So lets assume BO DEREK isnt in the list.
I type BO DEREK in cell A6
I then leave the cell & i then see BO DEREK 001 so this is working good.
So lets assume BOB BROWN is in the list 3 times.
BOB BROWN 001
BOB BROWN 002
BOB BROWN 003
I type BOB BROWN in cell A6 & the code checks column A for a match,the match is found and a Msgbox is shown advising me of the next number to use so BOB BROWN 004
OR better still if i type BOB BROWN & leave the cell have the codee just alter it to BOB BROWN 004 without the need for a msgbox
WHAT DO YOU THINK
THANKS
Over time i get repeat buyers of which i cant have the same name in the cell so it needs to be followed by a number etc.
So here is the example in the screens hot supplied.
I would advice on how i can overcome this.
I think the best thing to do would be to show a msgbox with the latest number should it be a duplicate ?
Some info for you.
Column A is where the customers name are.
The range will always be A6 then down the page.
So lets assume BO DEREK isnt in the list.
I type BO DEREK in cell A6
I then leave the cell & i then see BO DEREK 001 so this is working good.
So lets assume BOB BROWN is in the list 3 times.
BOB BROWN 001
BOB BROWN 002
BOB BROWN 003
I type BOB BROWN in cell A6 & the code checks column A for a match,the match is found and a Msgbox is shown advising me of the next number to use so BOB BROWN 004
OR better still if i type BOB BROWN & leave the cell have the codee just alter it to BOB BROWN 004 without the need for a msgbox
WHAT DO YOU THINK
THANKS