Hi, For the first excel give manual page numbering. For example: 21 in page number field and from next sheet use "Auto". If you preview the sheets indivdiuallay, page numbering may not be in sequenece. But, if you preeiw the whole work book, page numbers will be in sequene.
Thansk and regards, Naresh On 9/29/08, vivek jain <[EMAIL PROTECTED]> wrote: > > Dear All, > > I prepare project reports for my clients wherein I prepare the theory part > in MS Word & financials in MS Excel. > > In word I am able to give continuous page numbers. But in excel when I use > different sheets is there any possibility to give continuous page numbers > automatically. The numbers should start after the last page number in MS > Word. E.g. if the last page number in theory part is 12, in excel it should > start from13 and should continue in different sheets. And once completed can > I get a combined index. > > Thanks…. > > CA Vivek Jain, FCA > > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
