ExcelBanter - How can I Index (on words) a workbook in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I Index (on words) a workbook in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/235315-how-can-i-index-words-workbook-excel.html)

Guido Cole[_3_]

How can I Index (on words) a workbook in Excel?

I have about 150 worksheets in the same workbook. Each sheet contains a list
of different ingredients. I would like to make an index that shows me, on
which sheets each ingredient appears. Is there a way?
--
Guido

All times are GMT +1. The time now is 03:54 PM.