New Excel user quetion

[andyawad]

I hope some one can help me. I have no knowladge with VBA at all. But in my church we use quickbooks to keep record of donation. and for some reasone in quickbooks it does not gave you a report for each member with his total donation & Address so it is easy to send him a letter at the end of the year.

So we imported the data to excell and we would like to auto the forms.

I have one sheet with
1- completename
2- total donations

sheet 2
______
1-completename
2-address

I want to match the name and create a sheet with
1-completename
2-completeaddress
3-total donation

But I do not know how to match the name so the name match the donation

can it be done?
please help

Thanks in advance

[BenjieLop]

I hope some one can help me. I have no knowladge with VBA at all. But in my church we use quickbooks to keep record of donation. and for some reasone in quickbooks it does not gave you a report for each member with his total donation & Address so it is easy to send him a letter at the end of the year.

So we imported the data to excell and we would like to auto the forms.

I have one sheet with
1- completename
2- total donations

sheet 2
______
1-completename
2-address

I want to match the name and create a sheet with
1-completename
2-completeaddress
3-total donation

But I do not know how to match the name so the name match the donation

can it be done?
please help

Thanks in advance

You can have all your info summarized in Sheet 2.

1. Enter the formula in Cell C1

=vlookup(A1,Sheet1!$A$1:$B$100,2)

and copy down until all your requirements are met.


NOTE: The range $A$1:$B$100 assumes that there are 100 church members. If there are, let's say, xxx church members, then just replace the range with
$A$1:$B$xxx.

Hope this is the formula that you are looking for.

Regards.