Enter a name, copy and create a new worksheet which is titled the name entered

**Sparkie** · 06-19-2017, 01:26 AM

Help

I'm fudging my way through this so any help would be appreciated.

When I enter a name into worksheet "Girls" I would like to automatically have worksheet "Program Record" copied and its name changed to the name of the person. "Program Record" would then be the master for the copied worksheets.

Thanks for the help!
Sparkie

**jindon** · 06-19-2017, 01:52 AM

To "Girls" sheet code module.

Please Login or Register  to view this content.

Enter a name, copy and create a new worksheet which is titled the name entered

LinkBack

Thread Tools

Rate This Thread

Display

Enter a name, copy and create a new worksheet which is titled the name entered

Re: Enter a name, copy and create a new worksheet which is titled the name entered

Thread Information

Users Browsing this Thread

Similar Threads

VBA to hide a tab and create control button titled with tab name

look for value in column, create pages titled with value and put lines from row on pages

Create Macro to copy and paste data from one worksheet to another and enter page breaks

[SOLVED] Create new worksheet, unmerge and enter value, remove rows meeting criteria

Copy cell content in another worksheet and will not duplicate if same value is entered

Copy info from another worksheet only if certain data is entered

Enter numeric as text in Excel worksheet should not create error

Bookmarks

Bookmarks

Posting Permissions