Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rEPEATIMG TEMPLATE PAGE TO PAGE
i WANT TO REPEAT THE SAME TEMPLATE ON UPWARDS OF 200 PAGE WORKBOOK.
ESSENTIALLY I HAVE A FORM ( W/ BLANK ADDRESS AND COMMENT CELLS)THAT I WOULD NORMALLY PRINT 200 COPIES; THEN FILL OUT EACH OF THE PAGES BY HAND. i WANT TO TYPE THE INFORMATION RATHER THAN HAND WRITE. THERE ARE SOME CALCULATIONS--COLUMN TOTALS AND A RUNNING SUBTOTAL OF COLUMNS THAT NEEDS TO PRINT ON EACH PAGE. i WANT EACH PAGE TO LOOK LIKE THE NEXT PAGE EXCEPT OF COURSE FOR THE INFO-SPECIFIC ADDRESSES AND COMMENTS. THOUGHTS? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
rEPEATIMG TEMPLATE PAGE TO PAGE
Please get your caps lock key repaired so that you can stop SHOUTING.
-- David Biddulph "WINDING ROAD JUNKIE" <WINDING ROAD wrote in message ... i WANT TO REPEAT THE SAME TEMPLATE ON UPWARDS OF 200 PAGE WORKBOOK. ESSENTIALLY I HAVE A FORM ( W/ BLANK ADDRESS AND COMMENT CELLS)THAT I WOULD NORMALLY PRINT 200 COPIES; THEN FILL OUT EACH OF THE PAGES BY HAND. i WANT TO TYPE THE INFORMATION RATHER THAN HAND WRITE. THERE ARE SOME CALCULATIONS--COLUMN TOTALS AND A RUNNING SUBTOTAL OF COLUMNS THAT NEEDS TO PRINT ON EACH PAGE. i WANT EACH PAGE TO LOOK LIKE THE NEXT PAGE EXCEPT OF COURSE FOR THE INFO-SPECIFIC ADDRESSES AND COMMENTS. THOUGHTS? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
rEPEATIMG TEMPLATE PAGE TO PAGE
Maybe you could put the data in excel and use MSWord's mailmerge to create the
printouts. You may want to read some tips for mailmerge. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. Or use this technique from Debra Dalgleish's site: http://contextures.com/xlForm03.html WINDING ROAD JUNKIE wrote: i WANT TO REPEAT THE SAME TEMPLATE ON UPWARDS OF 200 PAGE WORKBOOK. ESSENTIALLY I HAVE A FORM ( W/ BLANK ADDRESS AND COMMENT CELLS)THAT I WOULD NORMALLY PRINT 200 COPIES; THEN FILL OUT EACH OF THE PAGES BY HAND. i WANT TO TYPE THE INFORMATION RATHER THAN HAND WRITE. THERE ARE SOME CALCULATIONS--COLUMN TOTALS AND A RUNNING SUBTOTAL OF COLUMNS THAT NEEDS TO PRINT ON EACH PAGE. i WANT EACH PAGE TO LOOK LIKE THE NEXT PAGE EXCEPT OF COURSE FOR THE INFO-SPECIFIC ADDRESSES AND COMMENTS. THOUGHTS? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template;insert a page | Excel Discussion (Misc queries) | |||
Need Sales Quote Template that carries over to more than one page | Excel Discussion (Misc queries) | |||
Getting a second page on a template.... | Excel Worksheet Functions | |||
Setting up page template | Excel Worksheet Functions | |||
when I try to download excel template, it says Error on page | Excel Discussion (Misc queries) |