Create Donation Receipt from Excel

[rizmomin]

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

[rizmomin]

Hello:

Someone please help/

Let me know if any questions.

[TMS]

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

[rizmomin]

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

[rizmomin]

Please help...

Thanks a lot

RM

[royUK]

You can adapt the code here

[rizmomin]

Hi Roy:

This will be the starting point and i am hoping that i will be able to manage.
Once again thanks a lot!!!!!

RM

[royUK]

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

[rizmomin]

Ho Roy:

It works for my need.
However i would love to have macro which will ask date or receipt # From and to.
Currenty i am changing the code to start and finish.

Please see if you can help with this.

Thanks a lot..

RM

[BigDawg15]

rizmomin,

Could you please post your completed file (with sensitive info deleted). I have been following this thread and would like to see the finished project.

Thank you in advance,

BigDawg15

[rizmomin]

Hi:

Please find the sheet requested.
However i would love to have macro which will ask date or receipt # From and to.
Currenty i am changing the code to start and finish.

Let me know if you have any questions

Thanks and give me update

RM

[BigDawg15]

rizmomin,

Thanks for the file. If I can come up with something, I will let you know.

Regards,

BigDawg15