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.