I have a spreadsheet for each month of 2010 (Jan-Dec) that is used to track church members donations by month. Under each month I have the last name, first name and weekly donation with the monthly donation total at the end of the row.
I would like to output on one page each person's name and monthly contributions and yearly total and disseminate to each member.
Anyone have an idea on how I could do this as 'automagically' as possible? Formulas, a form, I am puzzled on how to accomplish this short of a huge copy and paste operation.