10-14-2016, 04:09 AM
I've found a way for a worksheet in Excel to read its own assigned name:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
However, I'd like to make a summary worksheet that reads the frequently-updated names of other worksheets in the file. For example, if I have a file with worksheets named Summary, Specimen A, Specimen B, and Specimen C, I'd like the Summary sheet to have an automatically-updating table listing rows for Specimens A to C. Then when my boss decides to rename them Specimens 1, 2, and 3, I go through and rename the worksheets and the Summary sheet updates the table itself.
The problem is, references to other worksheets appear to need the current name of the worksheet.
Does anyone know how to do that?
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
However, I'd like to make a summary worksheet that reads the frequently-updated names of other worksheets in the file. For example, if I have a file with worksheets named Summary, Specimen A, Specimen B, and Specimen C, I'd like the Summary sheet to have an automatically-updating table listing rows for Specimens A to C. Then when my boss decides to rename them Specimens 1, 2, and 3, I go through and rename the worksheets and the Summary sheet updates the table itself.
The problem is, references to other worksheets appear to need the current name of the worksheet.
Does anyone know how to do that?
Mike Miller, Materials Engineer
----------------------
"Everbody's always in favor of saving Hitler's brain, but when you put it in the body of a great white shark, oh, suddenly you've gone too far." -- Professor Farnsworth, Futurama
----------------------
"Everbody's always in favor of saving Hitler's brain, but when you put it in the body of a great white shark, oh, suddenly you've gone too far." -- Professor Farnsworth, Futurama