Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default I want to create an A5 size invoice and print 2 copies A4 sheet

I want to create an A5 size small invoice, using Excel, so that I can print 2
copies side by side on an A4 sheet of paper. Have tried several times but it
never works out quite right. My printer is Hewlett Packard 5550 series.
Can anyone give me some help with this?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 694
Default I want to create an A5 size invoice and print 2 copies A4 sheet

Hi Libran:

Not a very elegant solution but why not just have two invoices side by side
on excel.

You could hide the second invoice and then when you print it out unhide it
with an onprint macro.

Give me your thaughts.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Libran19" wrote:

I want to create an A5 size small invoice, using Excel, so that I can print 2
copies side by side on an A4 sheet of paper. Have tried several times but it
never works out quite right. My printer is Hewlett Packard 5550 series.
Can anyone give me some help with this?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default I want to create an A5 size invoice and print 2 copies A4 shee

Thanks for the suggestion. Have just come out of hospital after a knee op so
will try it out soon and let you know.
Libran


"Martin Fishlock" wrote:

Hi Libran:

Not a very elegant solution but why not just have two invoices side by side
on excel.

You could hide the second invoice and then when you print it out unhide it
with an onprint macro.

Give me your thaughts.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Libran19" wrote:

I want to create an A5 size small invoice, using Excel, so that I can print 2
copies side by side on an A4 sheet of paper. Have tried several times but it
never works out quite right. My printer is Hewlett Packard 5550 series.
Can anyone give me some help with this?

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
How do I set up an Excel sheet to automatically print 3 copies? Sharellmae Excel Discussion (Misc queries) 0 January 4th 07 03:39 PM
ask for one print and it gives 6 copies raybag Excel Discussion (Misc queries) 0 October 17th 06 03:03 AM
print number of copies Sunny Excel Discussion (Misc queries) 1 August 29th 06 05:00 PM
how to change # or copies to print in a saved sheet? John Excel Discussion (Misc queries) 0 August 21st 06 05:01 PM
Print number of copies Tarique Excel Discussion (Misc queries) 2 April 24th 06 07:45 PM


All times are GMT +1. The time now is 02:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"