Create Receipt from Excel Data

[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)

As i get new member i will keep on adding member in this list.

Once i add new member i would need it sort the list Alphabettically automatically if possible.


I have another sheet called "Donation".

We will have donation for different project.

This will be listed as

column Croject A,

Column Droject B,

Column Eroject C,

Column Froject D,

Column Groject 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 C8

Date in I8

Type of Donation in C15 thru C30

Donation Amount in I15 thru I30

Total would be in C32.


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


Also i would also like to keep on updating Sheet "Summary" where i would have full summary of each members donation.


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

I could send you sample excel file if you like but do not know where to upload.


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


RM

 

[Faseeh]

Hi rizmomin,


Ever considered using Pivot tables, it will be an extremely handy tool for you. You can use Pivot table by itself to achieve the task or extract data using getpivotdata() if you want to workout any specific layout for receipt!!!


Faseeh

 

[rizmomin]

I can email you the excel sheet for you to understand..

Would you be able to give me email address..

Thanks