Forum Discussion
Referencing Entire Workbook
I am working to have a cell that includes all of the sheet names in a workbook that a certain value is present. For example, value=8,456; tabs where value is present B3 and C1; cell reads: B3, C1 My ...
Attached is the sample file for reference. Thanks for the help!
Hi Matt,
Ctrl + F or Find function usually works in activesheets only.
To do the that for entire workbook, just right click the tab -> Select All Sheets then go for Find Option.
As a variant instead of using
=MID(CELL("filename"),FIND("]",CELL("filename",D5))+1,256)you may extract sheet name from
=FORMULATEXT(D5)
SergeiBaklan wrote:As a variant instead of using
=MID(CELL("filename"),FIND("]",CELL("filename",D5))+1,256)you may extract sheet name from
=FORMULATEXT(D5)
That is a good idea, however, often the cells are set as values and no longer include the formulas. Any other ideas?
=MID(CELL("filename",'T1'!B1),FIND("]",CELL("filename",'T1'!B1))+1,256)if instead of D5 in formula you click on any cell in T1. For both CELL()
