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

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