Thread: Create Donation Receipt from Excel

Hello:

I am handling the book keeping part of our church donation.
I will have List of members in Sheet called "List"...in Column A (Full Name)

I have another sheet called "Donation".
We will have donation for different project.
This will be listed as
column C:Project A,
Column D:Project B,
Column E:Project C,
Column F:Project D,
Column G:Project E.


Column A : Date
Column B : Payee ( Here i would like to have a drop down list for me to choose from "List" Sheet.
Column C, D, E, F, G : Amount of Donation.

Now i need to generate a receipt of the donation to each member.

I like a macro to perform the following:

Allow me to choose From and to Date and transfer the data of each member in "Receipt" field as below:

Name in E14
Date in I8
Donation Amount in I24 thru I40
Total would be in I41.

Now it should allow me to choose the printer and print the receipts.

I would apprecicate if you could help me accomplish this and as always help is greatly appreciated.

Thanks and please let me know if you have any questions.

RM

See the attached updated sample workbook.

I'be added a named range and Data Validation to select the name, then VLOOKUPs to get the address details.

You'll need to add SUMPRODUCT or SUMIFS to the body of the receipt to complete it. As you've done similar stuff in the Summary sheet, you should be more than capable of doing this.


Regards, TMS

Thank you so much for getting me started.
I will start to carry per your guidance.
However, is it possible to have a VBA Macro to select date range (From to To ) in "Donation" sheet and then print a donation receipt automatically for each donor in a batch.

This is like asking "Please select date From and to print Receipt"

Your help is greatly appreciated.

Thanks
RM

You can adapt the code here

Thanks for the rep. Post back for any help adapting the code