alexm
07-23-2012, 12:28 AM
Hello,
I want to know if there is a way to insert the name of the worksheet in a cell, i've done it with this formula:
=MID(CELL("filename");SEARCH("[";CELL("filename"))+1;SEARCH(".xl?]";CELL("filename"))-SEARCH("[";CELL("filename"))-1)
The formula works, it shows the name of the workbook but i also need to link the cell to another workbook but i receive a "#value!" error.
I need to do this process for 50 files, in this 50 files i need this formula to show the name of each file inside of it, and after i need to link all the 50 file to another workbook who centralizes all the data in all the files.
thank you
Alex
I want to know if there is a way to insert the name of the worksheet in a cell, i've done it with this formula:
=MID(CELL("filename");SEARCH("[";CELL("filename"))+1;SEARCH(".xl?]";CELL("filename"))-SEARCH("[";CELL("filename"))-1)
The formula works, it shows the name of the workbook but i also need to link the cell to another workbook but i receive a "#value!" error.
I need to do this process for 50 files, in this 50 files i need this formula to show the name of each file inside of it, and after i need to link all the 50 file to another workbook who centralizes all the data in all the files.
thank you
Alex