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

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique