Creating, copying and renaming new worksheet based on specific cell contents

**johnejo** · 10-26-2012, 12:21 PM

Hello.

I am trying to find how when data is entered into cell (A7) of the main tab, that a new worksheet is automatically created, contents of another seperate non-active worksheet of the same workbook are copied to the new worksheet, and the new worksheet is renamed to the same as what was entered into cell (A7) on the main tab. Also, if what was in cell (A7) is changed after a new worksheet was already created that the corresponding worksheet is renamed accordingly.

I'm very green to VBA and macros so any help with this would be greatly appreciated.

Thank you.

**arlu1201** · 10-26-2012, 12:52 PM

It will be good if you attach a sample file.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.