I thought I posted this hours earlier today but it never showed up???
Anyway, I have one column of data with Depts and Names listed below the
dept. I need to printout one sheet for each dept and associated names.
Remember this is in one column:

Finance
Bob...
Julie...
(18 more names)
Marketing
Joe...
Fred...
Mary...
(9 more names)
Legal
bob...
Henry...
Manufacturing
(140 names)
many more departments with different numbers of names below each one.
thx