I have some inter-workbook links. The name of the worksheets within them might change occasionally.
I was going to use: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) to pull the worksheet name and use CONCATENATE to create all my references in my summary workbook.
To help visualize: I have about 40 budget workbooks, each with 5 - 15 worksheets. I'm making an at-a-glance summary book that will give me the amounts left in the different budgets and their catagories.
But, I realized even if I use the formula above to pull the changing worksheet name, I still won't be able to reference back to it in my summary workbook, since the origin worksheet name changed.
So... is there a way to PUSH that cell value to the unchanging workbook?
I was going to use: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) to pull the worksheet name and use CONCATENATE to create all my references in my summary workbook.
To help visualize: I have about 40 budget workbooks, each with 5 - 15 worksheets. I'm making an at-a-glance summary book that will give me the amounts left in the different budgets and their catagories.
But, I realized even if I use the formula above to pull the changing worksheet name, I still won't be able to reference back to it in my summary workbook, since the origin worksheet name changed.
So... is there a way to PUSH that cell value to the unchanging workbook?
