Alphanumeric Increment based on previous row value

Hi all, first post here, please be kind.

I'm in the process of learning by trying to create a fairly simple solution for my dad, who's far from an IT pro.

I have a sheet called customers, and on a separate sheet(Homepage) I have some buttons, one of them being 'Add Customer' and I have a vba macro for that, but it's not working 100%.

The first column contains Customer ID in alphanumeric format, e.g. ABC123 and this is the unique reference for the row. It is only the numeric part of the string that will change, first 3 characters stay the same.

I'm looking for my code to :

1- Find next empty row
2- Find last ID
3- Create new Customer ID


I've been reading all sorts of posts and watching tutorials etc, and I think I've just got myself in a muddle now. It has been slightly working but when I tried to tweak it to get it working perfectly, it all went a bit wrong. One of the strange things was that gave me MBL011 when there is already a MBL011 entry....... I have some data in the worksheet to work with, and some of that has been overwritten when I've been testing (god job I have a copy). I'm am quite happy with having to manipulate some data manually, especially to get the data back again (will be copy/paste).

This is my code that I currently have.....I think the error is on the strNextID, hence why I've been trying different ways.

Please Login or Register  to view this content.

Hiya, thanks for the response. I've given that a go but I'm getting a Type Mismatch error on the strNextID........ line. Any ideas?

Ok, thanks, think I've uploaded it correctly

Lovely, seems to be working like a treat. It does seem to enter the MBL number before the 'New Date Added succesfully' message and entering the inputted data, but I don't think that will be a problem, and I'm sure I could figure out how to sort it.

Thanks again, I'll marked as solved, add rep, and another other questions I'll post new thread.

Cheers

I meant sort in terms of fixing the problem lol, sorry.

I think the best course of action for me, for this little project, is to make a little bug list. For example, I can't get the next ID to show up on the message box. It's not crucial, but I'd obviously want to fix those little bits at a later date