Microsoft Office Forums - View Single Post - Compiling/Indexing hundreds of recipes + adding a search by ingredient function.

macropod · 08-13-2014, 03:09 PM

Unless each file is in the same format (e.g. a different row or column for every ingredient), you'll be unable to automate that. And, unless the ingredients and their quantities are differentiated into separate cells, a lot of processing overhead would be involved to do that for the destination workbook. Without such differentiation, you'd never be able to filter the destination workbook by ingredient.