Populate and create duplicates on second worksheet

L

Lee Radney

http://www.mediafire.com/download/t17v05fphj3om15/Donors_and_Transactions.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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top