Formula's in Excel

  blocker11 10:22 26 Sep 2007
Locked

Is there a Formula within excel which allows you to use, the "Sheet Name" as a cell value... i.e if you change the sheet name a particular cell changes to?

thanks

Steve

  Simsy 10:35 26 Sep 2007

you are renaming the sheet to something from a predetermined list of names, (which is elsewhere on the sheet), it would be possible.

If Not then VBA would be needed.

click here

and

click here

Good luck!

Regards,

Simsy

  VoG II 16:19 26 Sep 2007

=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?