Formula's in Excel

  blocker11 10:22 26 Sep 2007

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?



  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


click here

Good luck!



  VoG II 16:19 26 Sep 2007


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 ?