Thanks for the reply. But this method does not update page numbers automatically if any new page or sheet is inserted. Can it be done by some other method
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of TIWARI Sent: Monday, September 29, 2008 5:47 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Page numbering in excel Hello sir, First of all to to page preview and setup then go to page u write down on first page number remove auto and write down where u are starting the numbering of page for this sheet , then u go hearder or footer choose i.e page14 when ur sheet end e.i page no.20 then u go next sheet remove auto and write 21 I think ur problem have been solved. Tiwari 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 -~----------~----~----~----~------~----~------~--~---
