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

Worsheet name will change from template. Would like worksheet name to auto
print in cell on separate worksheet. Can this be done?

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

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


"Leslie" wrote:

Worsheet name will change from template. Would like worksheet name to auto
print in cell on separate worksheet. Can this be done?