I have a workbook (not created by me) that has all expenses per month on 1 sheet. There are 12 sheets in total. On the 13th sheet I would like to be able to input a name of a Vendor, which can either be in column C or E. If it finds it anywhere on the 12 pages it would return the entire row(s) back to me with the option to print it. With this being said there are 10 different workbooks that I would like it to sort through if need be. I've been searching for a way to do this.
