Update cell contents based on worksheet name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have the contents of a cell updated based on the name of a
worksheet?
 
A formula like:
=RIGHT(CELL("filename",A1),
LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))

will return the name of the worksheet (if the workbook has been saved).

You can use that long formula in an if statement--or put that formula in a cell,
then use a reference to that cell in your formula.
 
Back
Top