Hi -
Hope you're all well. I wanted to search for multiple text strings in excel and need to know which cells they are found in. So, for example, if there are 200 cells with text / numbers and the word "excel 101" appears in cells B2, C2, Z3 and AA3, I'd like excel to output these cells onto the sheet.
I dont think i can do this without VBA, but would appreciate your thoughts. I've attached the spreadsheet that shows me getting it working to confirm that the text does exist (Tab1), but I cannot get Tab 2 to work...
It would be great if you could help with this - with or without VBA
Dante
Bookmarks