Custom Excel Report - church contribution statements
Posted on 2015-01-27
I have an Excel spreadsheet with a church's donations setup for the year. The spreadsheet is setup with each donor's name address on the row along with their giving totals for each month of the year, and total for the entire year.
I'm wondering if its possible save me a ton of cut and paste work to create a custom report that will auto-populate a report for the donor contribution record.
Here are my columns
Donor Name | Address | Jan | Feb | Mar | Apr | May | June | Jul | Aug | Sept | Oct | Nov | Dec | Year Total
I'd like it to lay out
<header> (I can do this)
<donor Address> (this may require an intermediate step to separate address into columns (address, city,state,zip))
It would be awesome if I could setup the connections on the report "template" and then just create something to make it run and produce the reports.
Any Suggestions or direction is much appreciated. I'm not even sure what to call what I'm doing to look up in Google.
Thanks in advance.