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?