Create Multiple Receipts from worksheet

[Sheri66]

I'd like to use the attached receipt worksheet to create multiple receipts from a worksheet containing all the applicable data (source tab). It was originally set up to drop data from the Payment Receipt tab to a Receipt Log but that is the opposite of what I want it to do so I removed that and the accompanying macros. I want it to take the source data and create a single receipt for each donor. On the source sheet there are only two donors that have more than one item (Smith & Red). If there was only one line per donor I'd be using word mail merge, but alas that is not the case. I'm familiar with vba but only enough to be dangerous. BTW if this receipt looks familiar I took from a prior post to see if it was something I could do myself. Not...

[JBeaucaire]

No VBA yet, wanted to show you how to setup your template to minimize the VBA needed. The table B16:H20 has formulas in it that will cause the items to appear automatically based on the name entered into cell D10.

So you need only enter the name and increment the Receipt #.

There is no way in the workbook to complete the Donor information.