Hi Bill,

Thanks.

I am doing it the way as you describe, so I will do it the same way and just
auto filter it.

Thanks for your reply.

tabylee


Bill Manville wrote:
If I were doing this I would start from the other end.
I would have a single master list with all the information about all
the members, including which district they belong to.

Then, when I wanted a list for a particular district I would filter the
master list (Data Filter AutoFilter) to see just those people.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200912/1