New sheet related to template sheet with name

[Blaz_SLO]

Hello all,

I would be very grateful, if someone can help me with VBA code, because I am not an expert in this.


My idea is next, I have MainSheet, where I will put different names (1, 2, 3,....), each in separate cell in column. Also I have TemplateSheet with always the same datas. I would like to have button, which will generate new TemplateSheet
with its name related to input in cell.

I hope, that I was clear and it is understandable.


Many thanks in advance.

e123.jpg

[mehmetcik]

Your Proposed Solution is Messy and frankly pointless.

1. You do not need buttons.

2. Once Created what is the point of your Main Sheet

I have created a sample document for you.

Macro1.
Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code

Click on any green cell in column A of the Index Sheet one of two things will happen.
1. If the Sheet Exists then that sheet will be activated.
2. If that sheet does not exist then it will be created.


Macro2.
Select the Developer Tab. Select Visual Basic. Select view "Project Explorer". Select your project and click on "This Workbook"
Double Click on any cell on any sheet and the Index Sheet will be activated.

[Mumps1]

If you simply want to create a copy of the Template and name it using the values you enter in a column, using a different button for each value is not very practical. You can do what you requested by entering a value in a cell and simply pressing the RETURN key, no buttons are necessary. Would that work for you? If it would, in which column would you be entering the values to be used as sheet names?

[Blaz_SLO]

Hello mehmetcik

this document will help me control and maintenance my projects. In my Main Sheet I will have sum of all my projects with all main datas. In each separate sheet (named after project name) I will
have detailed informations of projects, pictures, notes,....



This is just my idea, any other solution is also welcomed.


Many thanks!

[Mumps1]

Try the attached sample file. In the MainSheet, type a value in column A and press the RETURN key. Does this do what you requested?

[Blaz_SLO]

Hello Mumps1

it will works too! Is it possible, that each next sheet is generated after previous one, now excel generate it before previously generated sheet.

If there is also any solution with button will be glad, because maybe other users will use this document, and now only I know, that I need to press return key (if there is a button, evertyhing is clear).

Many thanks!

[mehmetcik]

My Code Places each sheet at the end of the workbook. See Post number 2.

Please Login or Register  to view this content.

[Mumps1]

Try the attached file. It is possible to use buttons but that would mean that each button would have to have its own macro assigned to it. So if you have 5 buttons, you would need 5 macros. Then if you add any new buttons, you would have to reproduce the macro for each new button and change the cell reference to the appropriate sheet name. That is not very practical.

[Blaz_SLO]

Many thanks to both mehmetcik and Mumps1, all solutions will do the yob!

[Mumps1]

You are very welcome.

[Blaz_SLO]

mehmetcik,

in your first macro some errors appear:

1. When I select the whole row

Attachment 702060


2. When I select two cells:

Attachment 702061


Help with this is very appreciated.

[mehmetcik]

Try this code:

Please Login or Register  to view this content.

[Blaz_SLO]

Hello mehmetcik,

another additional problem occurred. When I double click in any cell in newly generated sheet (also in template sheet), Im redirected back to my Index sheet.

Is there any solution to this?



I must say, that your code for now is very useful.


Many thanks!

[mehmetcik]

As I explained in post no 2.

I place a macro in the This Workbook module to take you to the Index sheet on a double click. Delete it if you do not want it. But you will find it useful.


Select the Developer Tab. Select Visual Basic. Select view "Project Explorer". Select your project and click on "This Workbook"