Populate and create duplicates on second worksheet
 

http://www.mediafire.com/download/t1...nsactions.xlsx

The above is a copy of a spreadsheet that our NPO uses.

Ok excel gurus, what we need is for each new donation entered, a new donation receipt created with a page break in between. The columns to be populated are as shown on the sample donation receipt.

So, if for instance, we have 55 rows already, and we come in and add rows 56-60, it would create a new receipt for each row, populate each, so that we can print the five.

When we close the spreadsheet, it would be great to have that worksheet clean itself up.

I know you guys can do it!

Thanks!