--------------------------------------------------------------------------------

HI,

1. I would like to know if i can Auto name the sheet name.??

2. Also more if i would want to make changes to a workbook, can a seperate
sheet be created in the same existing workbook?

Plz Help.


Kulin.

You can create as many sheets in an existing workbook as your computer
memory can handle.
What do you mean by "Auto name the sheet name? Describe what you want to
do. HTH Otto
"Kulin Shah" wrote in message
...
--------------------------------------------------------------------------------

HI,

1. I would like to know if i can Auto name the sheet name.??

2. Also more if i would want to make changes to a workbook, can a seperate
sheet be created in the same existing workbook?

Plz Help.


Kulin.

Hi,

I wanted excel to create an auto sheet when changes made to the Master Sheet.

For eg if i have made a sheet with all my formulas etc (as default) and if
another user makes a change to the same then excel should automatically copy
the same data to another sheet with the new entered data. The Default one
will still remain in its place.

If yes then, can the new sheet prepared be renamed automatically for eg. if
Cell a1 = "abcd" then sheet will automatically be renamed as "abcd"

Is this possible.

Awaiting a reply.

Thanks,


Kulin

"Otto Moehrbach" wrote:

You can create as many sheets in an existing workbook as your computer
memory can handle.
What do you mean by "Auto name the sheet name? Describe what you want to
do. HTH Otto
"Kulin Shah" wrote in message
...
--------------------------------------------------------------------------------

HI,

1. I would like to know if i can Auto name the sheet name.??

2. Also more if i would want to make changes to a workbook, can a seperate
sheet be created in the same existing workbook?

Plz Help.


Kulin.

Yes, Excel can do that, but if you want this to happen automatically, Excel
needs to know WHEN to do that. You say whenever the user makes a change to
the sheet. To me that means when the user makes any change to any ONE cell
in the entire sheet. If you want this to happen after the user makes a
change to a specific cell, then you have to tell me what cell. Tell me
exactly when you want this to happen and I'll write some VBA code for you.
HTH Otto
"Kulin Shah" wrote in message
...
Hi,

I wanted excel to create an auto sheet when changes made to the Master
Sheet.

For eg if i have made a sheet with all my formulas etc (as default) and if
another user makes a change to the same then excel should automatically
copy
the same data to another sheet with the new entered data. The Default one
will still remain in its place.

If yes then, can the new sheet prepared be renamed automatically for eg.
if
Cell a1 = "abcd" then sheet will automatically be renamed as "abcd"

Is this possible.

Awaiting a reply.

Thanks,


Kulin

"Otto Moehrbach" wrote:

You can create as many sheets in an existing workbook as your computer
memory can handle.
What do you mean by "Auto name the sheet name? Describe what you want to
do. HTH Otto
"Kulin Shah" wrote in message
...
--------------------------------------------------------------------------------

HI,

1. I would like to know if i can Auto name the sheet name.??

2. Also more if i would want to make changes to a workbook, can a
seperate
sheet be created in the same existing workbook?

Plz Help.


Kulin.

Many thanks for understanding.

I would like Excel to create a new Sheet when Cell b3 is changed.

Also more if the user makes a further change in the new Sheet (in Cell b3)
will it again create a new Sheet? No i do not prefer this if possible.

Also auto rename of the new Sheet with Cell value in cell b1

Awaiting for your response.


"Otto Moehrbach" wrote:

Yes, Excel can do that, but if you want this to happen automatically, Excel
needs to know WHEN to do that. You say whenever the user makes a change to
the sheet. To me that means when the user makes any change to any ONE cell
in the entire sheet. If you want this to happen after the user makes a
change to a specific cell, then you have to tell me what cell. Tell me
exactly when you want this to happen and I'll write some VBA code for you.
HTH Otto
"Kulin Shah" wrote in message
...
Hi,

I wanted excel to create an auto sheet when changes made to the Master
Sheet.

For eg if i have made a sheet with all my formulas etc (as default) and if
another user makes a change to the same then excel should automatically
copy
the same data to another sheet with the new entered data. The Default one
will still remain in its place.

If yes then, can the new sheet prepared be renamed automatically for eg.
if
Cell a1 = "abcd" then sheet will automatically be renamed as "abcd"

Is this possible.

Awaiting a reply.

Thanks,


Kulin

"Otto Moehrbach" wrote:

You can create as many sheets in an existing workbook as your computer
memory can handle.
What do you mean by "Auto name the sheet name? Describe what you want to
do. HTH Otto
"Kulin Shah" wrote in message
...
--------------------------------------------------------------------------------

HI,

1. I would like to know if i can Auto name the sheet name.??

2. Also more if i would want to make changes to a workbook, can a
seperate
sheet be created in the same existing workbook?

Plz Help.


Kulin.

Otto Moehrbach wrote:
You can create as many sheets in an existing workbook as your computer
memory can handle.
What do you mean by "Auto name the sheet name? Describe what you want to
do. HTH Otto
"Kulin Shah" wrote in message
...
--------------------------------------------------------------------------------

HI,

1. I would like to know if i can Auto name the sheet name.??

2. Also more if i would want to make changes to a workbook, can a seperate
sheet be created in the same existing workbook?

Plz Help.


Kulin.




Pardon the intrusion off subject. Otto have been trying to contact you
regarding an update to the invoice template you did for us a few years
ago. All e-mails bounce back. Please contact me at .
Thanks,

Ed

HI Otto,

Many thanks for understanding.

I would like Excel to create a new Sheet when Cell b3 is changed.

Also more if the user makes a further change in the new Sheet (in Cell b3)
will it again create a new Sheet? No i do not prefer this if possible.

Also auto rename of the new Sheet with Cell value in cell b1

Awaiting for your response.

Many Thanks,


Kulin.
"Ed Thomas" wrote:

Otto Moehrbach wrote:
You can create as many sheets in an existing workbook as your computer
memory can handle.
What do you mean by "Auto name the sheet name? Describe what you want to
do. HTH Otto
"Kulin Shah" wrote in message
...
--------------------------------------------------------------------------------

HI,

1. I would like to know if i can Auto name the sheet name.??

2. Also more if i would want to make changes to a workbook, can a seperate
sheet be created in the same existing workbook?

Plz Help.


Kulin.




Pardon the intrusion off subject. Otto have been trying to contact you
regarding an update to the invoice template you did for us a few years
ago. All e-mails bounce back. Please contact me at .
Thanks,

Ed

Kulin
The following macro will do what you want.
Because you do not want a new sheet added if the user makes an entry change
in B3 of the new sheet, I needed to write the name of the original sheet
into the code in the macro. I assumed that name to be "First". Change that
name in the macro as needed. Therefore, as written, the macro will do
nothing if the name of the host sheet is not "First".
Note that if B1 is blank, the new sheet will have the default name of
"Sheetx" where "x" is the number of the next sheet to be created.
Note that this macro is a sheet macro and must be placed in the sheet module
of the "First" sheet. To access that module, right-click on the sheet tab,
select View Code, and paste this macro into that module. "X" out of the
module to return to your sheet. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
Dim DestWs As Worksheet
If Me.Name < "First" Then Exit Sub
If IsEmpty(Target.Value) Then Exit Sub
If Intersect(Target, Range("B3")) Is Nothing Then Exit Sub
Set DestWs = Sheets.Add(after:=Sheets(Sheets.Count))
On Error Resume Next
DestWs.Name = Range("B1").Value
On Error GoTo 0
End Sub

"Kulin Shah" wrote in message
...
HI Otto,

Many thanks for understanding.

I would like Excel to create a new Sheet when Cell b3 is changed.

Also more if the user makes a further change in the new Sheet (in Cell b3)
will it again create a new Sheet? No i do not prefer this if possible.

Also auto rename of the new Sheet with Cell value in cell b1

Awaiting for your response.

Many Thanks,


Kulin.
"Ed Thomas" wrote:

Otto Moehrbach wrote:
You can create as many sheets in an existing workbook as your computer
memory can handle.
What do you mean by "Auto name the sheet name? Describe what you want
to
do. HTH Otto
"Kulin Shah" wrote in message
...
--------------------------------------------------------------------------------

HI,

1. I would like to know if i can Auto name the sheet name.??

2. Also more if i would want to make changes to a workbook, can a
seperate
sheet be created in the same existing workbook?

Plz Help.


Kulin.




Pardon the intrusion off subject. Otto have been trying to contact you
regarding an update to the invoice template you did for us a few years
ago. All e-mails bounce back. Please contact me at .
Thanks,

Ed

HI Thanks fo the wonderful solution.

The formula actually helped.

But i wanted to copy the same Sheet (Template) to the new sheet if a cell is
changed. The orinal Template will remain blank as per originally made one.

I hope you can solve this as well.

Brgds. Kulin



"Otto Moehrbach" wrote:

Kulin
The following macro will do what you want.
Because you do not want a new sheet added if the user makes an entry change
in B3 of the new sheet, I needed to write the name of the original sheet
into the code in the macro. I assumed that name to be "First". Change that
name in the macro as needed. Therefore, as written, the macro will do
nothing if the name of the host sheet is not "First".
Note that if B1 is blank, the new sheet will have the default name of
"Sheetx" where "x" is the number of the next sheet to be created.
Note that this macro is a sheet macro and must be placed in the sheet module
of the "First" sheet. To access that module, right-click on the sheet tab,
select View Code, and paste this macro into that module. "X" out of the
module to return to your sheet. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
Dim DestWs As Worksheet
If Me.Name < "First" Then Exit Sub
If IsEmpty(Target.Value) Then Exit Sub
If Intersect(Target, Range("B3")) Is Nothing Then Exit Sub
Set DestWs = Sheets.Add(after:=Sheets(Sheets.Count))
On Error Resume Next
DestWs.Name = Range("B1").Value
On Error GoTo 0
End Sub

"Kulin Shah" wrote in message
...
HI Otto,

Many thanks for understanding.

I would like Excel to create a new Sheet when Cell b3 is changed.

Also more if the user makes a further change in the new Sheet (in Cell b3)
will it again create a new Sheet? No i do not prefer this if possible.

Also auto rename of the new Sheet with Cell value in cell b1

Awaiting for your response.

Many Thanks,


Kulin.
"Ed Thomas" wrote:

Otto Moehrbach wrote:
You can create as many sheets in an existing workbook as your computer
memory can handle.
What do you mean by "Auto name the sheet name? Describe what you want
to
do. HTH Otto
"Kulin Shah" wrote in message
...
--------------------------------------------------------------------------------

HI,

1. I would like to know if i can Auto name the sheet name.??

2. Also more if i would want to make changes to a workbook, can a
seperate
sheet be created in the same existing workbook?

Plz Help.


Kulin.




Pardon the intrusion off subject. Otto have been trying to contact you
regarding an update to the invoice template you did for us a few years
ago. All e-mails bounce back. Please contact me at .
Thanks,

Ed