L Leslie Mar 9, 2010 #1 Worsheet name will change from template. Would like worksheet name to auto print in cell on separate worksheet. Can this be done?
Worsheet name will change from template. Would like worksheet name to auto print in cell on separate worksheet. Can this be done?
E Eduardo Mar 9, 2010 #2 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
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
