Does anyone know if it's possible to search / filter more than 1 worksheet at a time? I have a workbook that contains 12 worksheets and if I looking for say, a clients name in all the worksheets right now the only way I can find / filter that clients name is by filtering each worksheet.

Thanks, Airpix