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?