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.