Hi Rajesh
Please follow below points.
1. Copy main sheet.
2. Paste six times and rename as Original for Buyers, Duplicate for Seller,
Triplicate............
3. When you made invoice select all copies and transact in original copy
it will changed in all copies
4. Don't alter in main head.
Please reply it's helpfull or not.
thanking you
you should copy main sheet and paste six times
On 22 February 2011 11:01, Rajesh Shah <[email protected]> wrote:
> Hello Members
> Good Day!
> I have a excel sheet (invoice copy) which i want to print 7 copies
> I have a problem with the header that i want to print. The header is
> different for all the 7 pages while all the other content remains the
> same.
>
> the header of the invoice in the first page to be printed should be "
> original for the buyer"
> the header of the invoice in the second page to be printed should be
> "Duplicate for the seller"
> the header in the third page should be " Transporter's Copy"
> and so on
>
> How do i over come this problem
> Can anyone help me
> Thanks a ton in advance
>
> Rajesh
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to [email protected]
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Sudhir Verma
Asstt. Mngr. A/c's
9818479722
*
P think Before you print
*
*
**
Life is Very beautiful !!!
*
*
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.
*
*
*
*Happy **Valentine** Day *
\ ¦ /
(ò ó)
_____ ___o0o___(_)___o0o__
___¦_____¦_____¦_____¦_____¦
¦_____¦_____¦_____¦_____¦__
___¦_____¦_____¦_____¦_____¦
*Drink Bear Save Water*
**
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
