ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,596
- Office Version
- 2007
- Platform
- Windows
Hi,
As per title looking for some input on an issue ive come just across.
I have a userform where i add various values in Textboxes etc related to the customer in question.
Example
JOHN SMITH has purchased an item from me, i complete the Textboxes on the userform & run the code on the command button which then places the values in the worksheet.
One of the things the code does is to look to see if there is a JOHN SMITH already present in column A
If NO then JOHN SMITH 001 is saved.
If YES the code looks at the 3 digit number & then saves like so JOHN SMITH 004
This tells me that there is JOHN SMITH 001 002 & 003
Each time at present "ANY" JOHN SMITH is saved a new 3 digit number is added which just follows on from the last saved 3 digit saved name
What i didnt factor into the equation when i started was what if there are more than one JOHN SMITH ?
I mean looking at the saved files 001 002 003 004 Doesnt mean its all for the same JOHN SMITH
Ive now got 2400 row & a few same name customers of which i wil;l have to open each file to see if same person or not.
But for the time being & moving forward can you advise how to overcome this in the future etc.
Thanks
As per title looking for some input on an issue ive come just across.
I have a userform where i add various values in Textboxes etc related to the customer in question.
Example
JOHN SMITH has purchased an item from me, i complete the Textboxes on the userform & run the code on the command button which then places the values in the worksheet.
One of the things the code does is to look to see if there is a JOHN SMITH already present in column A
If NO then JOHN SMITH 001 is saved.
If YES the code looks at the 3 digit number & then saves like so JOHN SMITH 004
This tells me that there is JOHN SMITH 001 002 & 003
Each time at present "ANY" JOHN SMITH is saved a new 3 digit number is added which just follows on from the last saved 3 digit saved name
What i didnt factor into the equation when i started was what if there are more than one JOHN SMITH ?
I mean looking at the saved files 001 002 003 004 Doesnt mean its all for the same JOHN SMITH
Ive now got 2400 row & a few same name customers of which i wil;l have to open each file to see if same person or not.
But for the time being & moving forward can you advise how to overcome this in the future etc.
Thanks