Can Sheet name be part of formula for a cell (+ sheet name)

  • Thread starter Thread starter Leslie
  • Start date Start date
L

Leslie

Worsheet name will change from template. Would like worksheet name to auto
print in cell on separate worksheet. Can this be done?
 
Hi,
You can have the name being printed in the worksheet you are in for example
in cell A1, enter

=MID(CELL("filename",C1),FIND("]",CELL("filename",C1))+1,255)

then go to the worksheet where you want the name to be populated and enter

=yoursheet name!A1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup 1
Update cell value based on name and specific date 1
Vlookup and return sheet name also 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Naming worksheets tabs from another cell reference 2
Auto worksheet name? 1
Can I use a worksheet name in a formula? 4
Auto Change Formulas - Please Help. 2

Back
Top