Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print
Hi, Excel Expert Gang,
I've tipical problem about my JV(Journal Vaoucher)printing. my layout is like this: Co. Name Header Date :___ JV# :_____ _______________________________ code |Description | Dr | Cr | Header -----|------------|-----|------| _____|____________|_____|______| _____|____________|_____|______| Detail section _____|____________|_____|______| _____|____________|_____|______| ______Total_________123___123__| Jv footer Approved By Prepared By footer My detail consist of 26 rows, ie fixed , if more it will start on next page with header and footer. Lets say when report is less than 26 rows still I need Blank rows with lines and at the end I'll get total. In short I want like pre-printed fixed format form. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print
Then you will have to treat your pages as
preprinted forms and carry your total lines per page to the next page. If you use the same sheet then you can use page breaks and OFFSET to get your previous balance. Because the have the restrictions of like preprinted forms you will not be able to insert or delete rows. -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Wahab" wrote in message ... Hi, Excel Expert Gang, I've tipical problem about my JV(Journal Vaoucher)printing. my layout is like this: Co. Name Header Date :___ JV# :_____ _______________________________ code |Description | Dr | Cr | Header -----|------------|-----|------| _____|____________|_____|______| _____|____________|_____|______| Detail section _____|____________|_____|______| _____|____________|_____|______| ______Total_________123___123__| Jv footer Approved By Prepared By footer My detail consist of 26 rows, ie fixed , if more it will start on next page with header and footer. Lets say when report is less than 26 rows still I need Blank rows with lines and at the end I'll get total. In short I want like pre-printed fixed format form. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
How can I print current row in same place on paper but not print surrounding cells??? | New Users to Excel |