Population of new tab with information in it.

[ferriskenny]

I have an excel sheet with multiple tabs. In stead of creating each tab individually with information in it, I would like to click a button that will populate a new tab, have the information in it, rename the tab, and create a new button for the new tab and rename that button. Is this possible?

[Kaper]

Yes it is.
If you think the answer is too short (but IMHO it addresses your question directly), consider attaching a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[ferriskenny]

Here is an example.