Recent content by opattison

Narayan, I cannot thank you enough for this, it is exactly what i need and works well with the slight adaption i made, great job. Best Regards, Owen

Of course this is fine, there is no rush any help you can give i am most grateful for thank you. Owen

Perhaps a better method would be for the formula in the look up sheet to add the increment there and it would be possible to add the text tag here if I'm not mistaken? then on my button click i could add the stream number dependent on the stream selected in the user form? sorry for the...

Yes i believe that is correct, Would this be possible to add in VBA to the button press and add a text tag such as SW/CW/D/UCL/MW before the number?

Hello Narayan, I have checked the workings of the maximum stream number and this is functioning well, obviously what I'm trying to end up with is something that does not require manual entry into the database sheet but everything is inputted from the userform 'Form'

Hello, So what i am looking to do with my userform is to have it so once the userform has been filled out you can click on the 'generate contract number' which will in turn search the database for the previous number and go 1 higher than that. the other part to this is that i would like it to...