Open New Work Sheet for projects on Main sheet and when new projects are added

[Luke4]

Hi,

I have an excel document with a list of projects and need to do notes for each project.
I want to open a worksheet for each project and for the new added projects with a VBA code.
The new worksheet needs be be labeled with the name of the project/s
There also need to be a lay-out on these newly added worksheets
refer to example below.
I have placed the information in the same location as per my original sheet

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Open New Work Sheet for projects on Main sheet and when new projects are added

Hi, I have an excel document with a list of projects and need to do notes for each project. I want to open a worksheet for each project and for the new added projects with a VBA code. The new worksheet needs be be labeled with the name of the project/s There also need to be a lay-out on...

www.excelforum.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.