UserForm that creates a new sheet as needed

**rscarbo** · 09-12-2014, 05:10 PM

Hi. I have a workbook that has summary reports for different departments each day. I'd like to have a userform where they can enter their data and depending on their department, create a new worksheet as needed. Only about 50% of the departments submit forms each day, so I don't want the excess forms for the days where the departments are inactive.

Is this even possible?

Thanks.

**Leith Ross** · 09-12-2014, 06:36 PM

Hello rscarbo,

Please post your workbook. It would help to see your layout and any formulas or code you have written.

Please redact any sensitive or confidential information before you upload the workbook.

How To Post Your Workbook

At the bottom right of the Reply window, Click the button Go Advanced
At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
Click the Select Files button at the bottom middle of the dialog.
In the new window Find the file you want to upload, select it, and Click Open.
You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
Wait until the file has completely uploaded before you exit the File Manager dialog.