Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to create a list of non-duplicates JRobertson New Users to Excel 1 January 13th 12 04:37 AM
Populate and entire row while removing duplicates. NightLord Excel Discussion (Misc queries) 2 September 25th 08 07:08 AM
Create Combo Box and Populate OssieMac Excel Programming 3 October 28th 07 07:59 PM
Create & Name new Sheets without duplicates [email protected] Excel Programming 2 December 29th 06 10:43 PM
Create worksheets and populate Alberto Pinto Excel Programming 5 October 31st 06 02:21 AM


All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"