I have a huge workbook with 100+ sheets and am having to search through the whole thing for multiple values. I was wondering is there might be a way I could create another workbook that could find all of the rows that contain the value "1" and collate them into a single workbook? The whole workbook looks something like this:
|