Automatic Cell name change - Tab name

[amir9s]

Hi guys,

I've seen people post how to change a Tab name based on a cell's value/name using a macro, but what I'm looking for is the exact opposite.

I need to have a cell's name/value change based on a tab's name.

Would appreciate the help. Thank you

 

[JoeMo]

Hi guys,

I've seen people post how to change a Tab name based on a cell's value/name using a macro, but what I'm looking for is the exact opposite.

I need to have a cell's name/value change based on a tab's name.

Would appreciate the help. Thank you

You don't need a macro. Here's a formula you can put in that cell:

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

 

[amir9s]

You don't need a macro. Here's a formula you can put in that cell:

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

Thank you, that worked just fine

 

[JoeMo]

Thank you, that worked just fine

You are welcome - thanks for the reply.