Hi Jitender, it's done without using vba coding
just change CODE On Mon, Feb 21, 2011 at 8:50 PM, Jitender kumar <jk9779771...@gmail.com>wrote: > > > On 21 February 2011 10:25, anil panchal <anil.kan...@gmail.com> wrote: > >> please send sample file. >> >> >> On Sun, Feb 20, 2011 at 10:05 PM, jaibeersingh panwar < >> panwar.jaibeersi...@gmail.com> wrote: >> >>> Hi Jitendra, >>> >>> If you have that excel sheet forward it to us.. empty one will do.. >>> Regards, >>> Jaibeer >>> >>> >>> On Sun, Feb 20, 2011 at 4:38 PM, Jitender kumar < >>> jk9779771...@gmail.com> wrote: >>> >>>> Dear Excel Guru, >>>> >>>> 1. I have address book in Excel in following format. How to print 15 >>>> address label in A4 paper Sticker using excel.Pl attach a sample sheet(if >>>> uses VBA or else) >>>> >>>> S.no Empcode Name FName Address1, Address 2, City, State, >>>> PIncode, Mobile >>>> >>>> It should be printed like this >>>> >>>> Name (Empcode) >>>> Address1 >>>> Address2(if blank omits) >>>> City Pincode >>>> State >>>> Mobile >>>> >>>> pl help >>>> Thx in advance >>>> >>>> Regards >>>> >>>> Jitender >>>> >>>> >>>> >>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> 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 excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> 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 excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> >> >> >> Thanks & Regards >> Anil Kumar >> >> > -- > > ---------------------------------------------------------------------------------- > 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 excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- One Team One Dream One Goal Warm Regards, *Vikas Chauhan* E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_*ccess *without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- ---------------------------------------------------------------------------------- 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 excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Copy of Book1.xls
Description: MS-Excel spreadsheet
