First reply to multiple spreadsheets
Do not close the window with the Macro yet. When INDEX and MATCH are used together, we like to start from within the Excel workbook containing the phantom links. You'll be able to see the value of the primary column for that row To find results that contain any of the included words Type OR between multiple search terms. How To Insert Rows In Multiple Sheets in Excel ExcelDataPro.