Hi there, just registered on this forum and i'll immediately apologise for the easy answer this probably has....I'm sort of OK with the basics of Excel, but I am being asked to look at getting into VBA and macros now so some baby steps are probably required.
My issue is that my Company has a list of self generated manufacturing codes separated by a colon. So for example there's a code for a product (D-), where it is mounted on the board (S-) and then a unique 'next' number. THese numbers have been previously created by a Purchasing team. The problem in the past has been that the numbers have been created by 3 or 4 users, and in the past this has created duplication and overwrites (the database in which these details have been added is dire...
I've been asked to provide a simple method of creating a unique 'next' number based on the two prior parameters.My Purchasing team need a quick way (a VB program even) to quickly add a reference from column A (in a search box), and a reference from Column B (in a search box) and then the resulting box would produce the next number based on the parameters entered!
So for example, column A is the product, B is the Mount, so A and B equate to a current serial number. If A and B appear again, then its the next number in the sequence. (sorry for the additional columns, I've had to concatenate and unconcatenate to get some of my own formula tests
C M 1004 C-M-1004 C-M-1004
C S 1005 C-S-1005 C-S-1005
C S 1006 C-S-1006 C-S-1006
C S 1007 C-S-1007 C-S-1007
C S 1008 C-S-1008 C-S-1008
A S 1000 A-S-1000 A-S-1000
A S 1001 A-S-1001 A-S-1001
A S 1002 A-S-1002 A-S-1002
A S 1003 A-S-1003 A-S-1003
A M 1004 A-M-1004 A-M-1004
A M 1005 A-M-1005 A-M-1005
A M 1006 A-M-1006 A-M-1006
R M 1001 R-M-1001 R-M-1001
R S 1002 R-S-1002 R-S-1002
Bookmarks