Dear All,

I am new to this forum and looking your guideline on Excel 2003 vba.

I have userform which transfer data from userform to worksheet. It is working perfect, but I would like to transfer data to a specified (textbox value)worksheet, if specified worksheet not found then copy previous worksheet and rename to textbox value then transfer data.

Thanks in advance for your input.