hi,

I am making a church donation file in Excel.

We have now about a hundred plus donors. The number of new donors are still
increasing. At present, I am using data validation with drop down list.

My main problem is the every week there are about 2 or 3 new donors. Donors
usually use aliases instead of their real names such as Amazing Grace, 008 or
Love etc. The list is getting long. I have to update the names in the list
first.

I would like to ask for your expert advice, is it better to continue using
the data validation list or type the name of donors?

In case, I need to get the total amount a certainn donors has given, I may
use filter or the sumif functions.

hope to be enlighten.

Tabylee

--
Message posted via http://www.officekb.com