#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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 and regards
Wahab
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
Print and Print Preview Graphic Moving Resizing 2007/2003 Adam Rayburn Excel Discussion (Misc queries) 0 April 4th 07 04:18 PM
cell borders that I create dont show on print preview or print scott3435 Excel Discussion (Misc queries) 2 April 6th 06 02:37 AM
Pivot Table macro to set print area and print details of drill down data Steve Haskins Excel Discussion (Misc queries) 2 December 28th 05 04:59 PM
Active cell counting in particular print page (one sheet having different print area) ananthmca2004 Excel Worksheet Functions 1 November 24th 05 11:29 AM
Macro to open print window and set to print entire workbook retseort Excel Discussion (Misc queries) 1 October 27th 05 11:00 PM


All times are GMT +1. The time now is 05:30 PM.

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"