Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-25-2018, 04:22 PM
Marcia's Avatar
Marcia Marcia is offline Macro to print a value in the duplicate and triplicate copies only Windows 7 32bit Macro to print a value in the duplicate and triplicate copies only Office 2007
Expert
Macro to print a value in the duplicate and triplicate copies only
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Macro to print a value in the duplicate and triplicate copies only


One of the office tasks is to print check payments. The checks have serial numbers that must be printed on the duplicate and triplicate copies. what is the macro so that when printing three copies of the check, the serial numbers (E2) are printed on the duplicate and triplicate copies only? The original copy is the check itself while the duplicate and triplicate copies are just plain blank bond papers for record purposes. Check sample attached.
Attached Files
File Type: xlsx check sample.xlsx (15.3 KB, 13 views)
Reply With Quote
  #2  
Old 09-25-2018, 05:25 PM
trevorc trevorc is offline Macro to print a value in the duplicate and triplicate copies only Windows 7 32bit Macro to print a value in the duplicate and triplicate copies only Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

[quote=Marcia;133733]One of the office tasks is to print check payments.

You don't need a macro, just setup 3 copies of the receipt (after doing a print preview you will see the printer margins, use these to place your extra 2 copies and were there is a duplicate serial put in it's place =E3. Then print the sheet and you should get 3 copies.
Reply With Quote
  #3  
Old 09-26-2018, 02:11 PM
Marcia's Avatar
Marcia Marcia is offline Macro to print a value in the duplicate and triplicate copies only Windows 7 32bit Macro to print a value in the duplicate and triplicate copies only Office 2007
Expert
Macro to print a value in the duplicate and triplicate copies only
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

[QUOTE=trevorc;133735]
Quote:
Originally Posted by Marcia View Post
One of the office tasks is to print check payments.

You don't need a macro, just setup 3 copies of the receipt (after doing a print preview you will see the printer margins, use these to place your extra 2 copies and were there is a duplicate serial put in it's place =E3. Then print the sheet and you should get 3 copies.
Thank you Trevorc, your suggestion never entered my mind. We had been manually typing and deleting the serial numbers. The checks however are printed vertically so I spent time adjusting the margins to get the page accommodate three copies. Again, thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to print a value in the duplicate and triplicate copies only Unable to get two copies of a table to print Enoch Word Tables 2 08-08-2018 03:55 PM
Print copies of onepage document with different text kciejek Word VBA 4 06-03-2014 03:21 AM
Macro to print a value in the duplicate and triplicate copies only Unable to print multiple copies zip p pong Word 1 03-16-2014 08:56 PM
Macro to print a value in the duplicate and triplicate copies only Mutliple copies 167 print as one document John-N Mail Merge 5 02-19-2012 07:15 PM
Print copies not resetting? denisep98 Word 0 09-14-2009 08:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft