| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup inventory to a receipt | Excel Discussion (Misc queries) | |||
| Finding last receipt number in a column ? | Excel Worksheet Functions | |||
| donation tracking with sub totals for donor | Excel Discussion (Misc queries) | |||
| how to print a receipt | New Users to Excel | |||
| receipt template | Excel Worksheet Functions | |||
Hybrid Mode
