Name a worksheet base on cell value

[Mskrn]

Hello everyone,

Is there a simple way to name a worksheet with reference to a cell in a particular sheet (using excel formula instead of VBA)? E.g. If I type "Product A" in cell A1, then another worksheet will be named Product A...if I change cell A1 to "Product A ver2", the worksheet name will be updated automatically.......thanks in advance!!!

[FDibbins]

No, this will require VBA

[bebo021999]

Formula can not help to name a sheet. only VBA.

[Mskrn]

I see......thanks...