I can filter a worksheet with the lookup tool but I would like to use it
through out the file. All of the worksheets in the current workbook and I
want to sum a colum of the result set! How do I do this? Can I make a macro
to do this?