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 current function is: =MID(CELL("filename"),FIND("]",CELL("filename",A1))+1,256) which returns the current tab name but doesn't search this rest of the workbook. Any help would be more than appreciated!!
18 Replies
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?
