ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   rEPEATIMG TEMPLATE PAGE TO PAGE (https://www.excelbanter.com/excel-discussion-misc-queries/209205-repeatimg-template-page-page.html)

WINDING ROAD JUNKIE

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?

David Biddulph[_2_]

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?




Dave Peterson

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


All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com