Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |