Formula's in Excel

  blocker11 10:22 26 Sep 07
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 07

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 07

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

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

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…