I am working with a workbook that has over 300 individual sheets. I would like to know the easiest way to create something that will let me enter a particular item and then have it search the entire workbook. I would like to populate a separate sheet with the top line of each sheet when my search item is found on that sheet.
Bookmarks