Dear Experts,
I have 28 worksheets (drug classes) each with a column O in which drug names
will appear if they meet certain criteria. I would like to list these drugs,
from the 28 worksheets on one page, as a summary. I want excel to look down
column O, for about 100 rows, and collect any occurrences of drug names. In
100 rows drug names may appear 20 times (they will all be unique), the other
cells being blank. Can I collect these occurrences on one sheet for summary
purposes?

regards
Martina