I have a combobox called 'cmbkids' on a form named 'Hideform'. On the press of a button I want to search for a 4 digit number within the string that is currently selected in the combobox. The string might look something like this 'Adam,Cordliffe - 1301 - Round 2', but might also sometimes look like this '1301 - Adam,Cordliffe - Round 2' so the position of the 4 digit number is not fixed.
Once it has found the 4 digit number I need to then lookup that number in column A of worksheet 'KidsDB', and then copy columns A to C of that row and paste to the next available row in another worksheet named 'Register'.
I'm really stuck at this point in my project and any help would be appreciated.
Even if you only have part of the solution please point me in the right direction.
Thanks Guys!!
Once it has found the 4 digit number I need to then lookup that number in column A of worksheet 'KidsDB', and then copy columns A to C of that row and paste to the next available row in another worksheet named 'Register'.
I'm really stuck at this point in my project and any help would be appreciated.
Even if you only have part of the solution please point me in the right direction.
Thanks Guys!!