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!!
Attached are screenshots for clarity. Thanks for the help!Formula Tab.PNGREF tab.PNG
Last edited by mattmccormack1; 04-18-2018 at 02:28 PM.
If anyone could speak to the feasibility of this that would be greatly appreciated.
I think you're going to need a macro to do this. I know of no way to search multiple sheets using a formula especially if you don't know all the sheet names at the time you write the formula.
An image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks