I'm working on a spreadsheet for my club. I want to keep track of money
collected and to provide a printout for each member's total donation at the
end of the year. I have a list of members' names (300 people). I tried using
Access but had problem with the pull-down and selecting an individual member.
What's the best way to create the spreadsheet? One member may pay several
times a year. Should I have one worksheet with member's name that points to
another worksheet that allows me to enter date/money turned in? Again, at
the end of the year, I want to be able to print out the total member's
donation. THANK YOU!