Donation receipt form
 

I have a workbook that tracks donations for our church. The Records sheet
tracks weekly giving for every giver. Column A is the names of the givers &
Row 1 is the weekly dates for 2008. What I need to do is transfer this info
to a Donation Receipt sheet at the end of the year that is setup with the
dates down column A & the amount given each week down column B. I'm using
vlookup to pull the names & addresses, from the Records sheet to the Donation
Receipt sheet, but I'm not sure what I need to do to accomplish the rest of
this.
The donation receipt should list what was given by a particular donor every
week, but I don't want it to list weeks that the giver did not donate; I just
want the form to list every week that a donation was recorded for that giver
on the Records Sheet. What kind of formula or Macro can I use to accomplish
this?

Donation receipt form
 

Hi

Presumably you have 54 columns on the Records sheet, 1 for Name and one for
each of 53 possible weeks.

On your Donation Receipt Sheet, I am assuming the Donor's name is in A1
(change to suit), and that you are beginning your list of donations on row 5
of that sheet.
In A5 enter
=INDEX(Records!$1:$1,Row(a2))
in B5 enter
=IF(ISNA(VLOOKUP$A$1,Records!$A:$BB,Row(A2),0)),"" ,VLOOKUP$A$1,Records!$A:$BB,Row(A2),0))
Copy both formulae down for 53 rows
Select A5:B58Paste SpecialValues
Select A5:B58DataSortB5Ascending
All of the weeks with no donation, will now Sort to the end.
Delete the blank value rows
Select the block of data and sort again by column B to put back in Date
Order.

You could record a macro whilst doing this, apart from deleting the blank
value rows, and run it for each person.
--
Regards
Roger Govier

"Montana" wrote in message
...
I have a workbook that tracks donations for our church. The Records sheet
tracks weekly giving for every giver. Column A is the names of the givers
&
Row 1 is the weekly dates for 2008. What I need to do is transfer this
info
to a Donation Receipt sheet at the end of the year that is setup with the
dates down column A & the amount given each week down column B. I'm using
vlookup to pull the names & addresses, from the Records sheet to the
Donation
Receipt sheet, but I'm not sure what I need to do to accomplish the rest
of
this.
The donation receipt should list what was given by a particular donor
every
week, but I don't want it to list weeks that the giver did not donate; I
just
want the form to list every week that a donation was recorded for that
giver
on the Records Sheet. What kind of formula or Macro can I use to
accomplish
this?

Donation receipt form
 

A church that keeps records of donations and names and addresses
of people who donate to it are nothing but a bunch of thieves operating
under the guise of religion.

Whoever you are get out of this newsgroup!
You are a disgrace to humanity!

Marcus


"Montana" wrote in message
...
I have a workbook that tracks donations for our church. The Records sheet
tracks weekly giving for every giver. Column A is the names of the givers
&
Row 1 is the weekly dates for 2008. What I need to do is transfer this
info
to a Donation Receipt sheet at the end of the year that is setup with the
dates down column A & the amount given each week down column B. I'm using
vlookup to pull the names & addresses, from the Records sheet to the
Donation
Receipt sheet, but I'm not sure what I need to do to accomplish the rest
of
this.
The donation receipt should list what was given by a particular donor
every
week, but I don't want it to list weeks that the giver did not donate; I
just
want the form to list every week that a donation was recorded for that
giver
on the Records Sheet. What kind of formula or Macro can I use to
accomplish
this?

Donation receipt form
 

"Marcus" wrote in message
...
A church that keeps records of donations and names and addresses
of people who donate to it are nothing but a bunch of thieves operating
under the guise of religion.

Whoever you are get out of this newsgroup!
You are a disgrace to humanity!



Churches, or any registered charity, can reclaim the tax already paid on
money donated. To do so they require the details of the person giving the
money. There is nothing sinister about it and there is no need to be so
offensive.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

Donation receipt form
 

This is a deep issue and everyone will have different opinion.
Mine ? Lets just concentrate in the excel part.
See what happens? I'm telling you to do something and
I'm not doing it. Shame on me.
Anyways...
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"Sandy Mann" wrote:

"Marcus" wrote in message
...
A church that keeps records of donations and names and addresses
of people who donate to it are nothing but a bunch of thieves operating
under the guise of religion.

Whoever you are get out of this newsgroup!
You are a disgrace to humanity!



Churches, or any registered charity, can reclaim the tax already paid on
money donated. To do so they require the details of the person giving the
money. There is nothing sinister about it and there is no need to be so
offensive.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

Donation receipt form
 

I don't see it as being a deep issue at all, I was merely pointing out that
it is a tax thing and regardless or marcus' opinion there is no need to be
abusive.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Learning Excel" wrote in message
...
This is a deep issue and everyone will have different opinion.
Mine ? Lets just concentrate in the excel part.
See what happens? I'm telling you to do something and
I'm not doing it. Shame on me.
Anyways...
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"Sandy Mann" wrote:

"Marcus" wrote in message
...
A church that keeps records of donations and names and addresses
of people who donate to it are nothing but a bunch of thieves operating
under the guise of religion.

Whoever you are get out of this newsgroup!
You are a disgrace to humanity!



Churches, or any registered charity, can reclaim the tax already paid on
money donated. To do so they require the details of the person giving the
money. There is nothing sinister about it and there is no need to be so
offensive.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

Donation receipt form
 

I'm with you my friend.
Totally agreed.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"Sandy Mann" wrote:

I don't see it as being a deep issue at all, I was merely pointing out that
it is a tax thing and regardless or marcus' opinion there is no need to be
abusive.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Learning Excel" wrote in message
...
This is a deep issue and everyone will have different opinion.
Mine ? Lets just concentrate in the excel part.
See what happens? I'm telling you to do something and
I'm not doing it. Shame on me.
Anyways...
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"Sandy Mann" wrote:

"Marcus" wrote in message
...
A church that keeps records of donations and names and addresses
of people who donate to it are nothing but a bunch of thieves operating
under the guise of religion.

Whoever you are get out of this newsgroup!
You are a disgrace to humanity!



Churches, or any registered charity, can reclaim the tax already paid on
money donated. To do so they require the details of the person giving the
money. There is nothing sinister about it and there is no need to be so
offensive.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

Donation receipt form
 

Thanks Roger, that got me off to the right start.

"Roger Govier" wrote:

Hi

Presumably you have 54 columns on the Records sheet, 1 for Name and one for
each of 53 possible weeks.

On your Donation Receipt Sheet, I am assuming the Donor's name is in A1
(change to suit), and that you are beginning your list of donations on row 5
of that sheet.
In A5 enter
=INDEX(Records!$1:$1,Row(a2))
in B5 enter
=IF(ISNA(VLOOKUP$A$1,Records!$A:$BB,Row(A2),0)),"" ,VLOOKUP$A$1,Records!$A:$BB,Row(A2),0))
Copy both formulae down for 53 rows
Select A5:B58Paste SpecialValues
Select A5:B58DataSortB5Ascending
All of the weeks with no donation, will now Sort to the end.
Delete the blank value rows
Select the block of data and sort again by column B to put back in Date
Order.

You could record a macro whilst doing this, apart from deleting the blank
value rows, and run it for each person.
--
Regards
Roger Govier

"Montana" wrote in message
...
I have a workbook that tracks donations for our church. The Records sheet
tracks weekly giving for every giver. Column A is the names of the givers
&
Row 1 is the weekly dates for 2008. What I need to do is transfer this
info
to a Donation Receipt sheet at the end of the year that is setup with the
dates down column A & the amount given each week down column B. I'm using
vlookup to pull the names & addresses, from the Records sheet to the
Donation
Receipt sheet, but I'm not sure what I need to do to accomplish the rest
of
this.
The donation receipt should list what was given by a particular donor
every
week, but I don't want it to list weeks that the giver did not donate; I
just
want the form to list every week that a donation was recorded for that
giver
on the Records Sheet. What kind of formula or Macro can I use to
accomplish
this?