![]() |
#1
|
|||
|
|||
![]()
im doing an invoice at work i would like to print of 3 invoices that nearly the same but on one invoice it has delivery note other has customer copy and last one to have accounts
is their a way to just print once and 3 pieces of paper to come out page 1 to say delivery note page 2 to say customer copy page 3 to say accounts ive recorded a macro so i can change it just by pressing ctrl D, ctrl C and ctrl A |
#2
|
|||
|
|||
![]()
p.s i am using microsoft office 2007
|
#3
|
|||
|
|||
![]()
Just off the top of my head, you could have the three on separate tabs with the common fields for two populated by the third.
|
#4
|
|||
|
|||
![]()
Thanks i try that tomorrow i just want a way that if i click print once it print of 3 copies the same only difference is delivery note. Customer copy and accounts
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro Needed to bold specific lines and Macro to turn into CSV | anewteacher | Word VBA | 1 | 05-28-2014 03:59 PM |
custom icon, undo/redo for macro, permanent macro | Rapier | Excel | 0 | 08-05-2013 06:30 AM |
How do I assign a macro to a button when the macro is in my personal workbook? | foolios | Excel Programming | 2 | 07-27-2011 02:41 PM |