I think a pivot table will be able to do something similar to what you are
looking for. You would need to set it up to run off of the master sheet. The
one down side, it would set things up transposed from your example,

task 1 joe
sam
task 2 rob
kim
abe
--
Best Regards,

Luke M


"stocktsi" wrote:

I've got a workbook set up with multiple tabs. Each tab represents a
different slice of detailed information that's auto-filtered based on a
status in a master tab (ie - all info in the master tab, different filters in
the other tabs.)

I'd like to create a summary tab that shows a subset of the data on the
individual tabs. I've been able to display counts of the information
(countif...), but don't know how to display a couple of columns of the
information. For example:

master tab "1" tab "2" tab
------------ -------- --------
joe 1 2 3 joe 1 2 3 ron 2 6 7
sam 1 4 5 sam 1 4 5 kim 2 7 8
ron 2 6 7 abe 2 9 9
kim 2 7 8
abe 2 9 9

I'd like the summary tab to look like:

task 1 task 2
----------- --------
2 people 3 people
joe ron
sam kim
abe

If I use an If statement to screen rows out, I get blank rows. If I use
filters, the rows don't match so data isn't shown. Is there a way to do this
without creating a macro to screen things out and condense them?

Thanks.