人気ブログランキング | 話題のタグを見る

Troubleshooting:different pagenation of a worksheet

different pagenation of a worksheet

·        I have a worksheet of over 50 pages with auto pagenation & date. I need to indicate modification in  few pages and apepend (R) with page no.
and diffrent date. As auto page number ie. Page-1, Page-2,
Page-3, Page-4......
and date 11/11/2010...Example: I want to see page modified ( say in page-2) and the pagination shall be Page-2(R) instead of Page-2 and date 13/11/2010.
Any macro help to make it .
Regards,
Thanks
mshams

Anwsers to the Problem different pagenation of a worksheet

Download Error Fixer (Free)

mshams,
 
it is unclear what you mean by a revised page.  If you are asking Excel to automatically recognize the page as revised and change the page numbering to append the R only for that page, I am afraid there will be no built in capability to support that.  header
and footer settings are predominantly at the worksheet level.  In Excel 2007 there are options for unique odd and even pages and for the first page, but beyond that there are no options. 
 
workarounds might be printing all the pages, then change the header or footer to show the R and then print only the revised pages.  then insert them into the original printing.  then change the header or footer back.
another might be to copy the sheet and remove non-revised pages from the copy.   this would really depend on how your sheet is laid out and the use of formulas an so forth.  A modified version of this is to copy the revised pages and paste to a second sheet
as a linked picture. 
--
Regards,
Tom Ogilvy

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Update and run your antivirus software. Windows doesn't come with antivirus software, but Action Center can often monitor the antivirus software that you or your computer manufacturer have installed.

Another Safe way to Fix the Problem: different pagenation of a worksheet:

How to Fix different pagenation of a worksheet with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.


Related: Way to Update & Download SONY SVE14A2X1EH Wireless State Device driver,How to Update & Download SONY SVS1511X9RB Graphics Driver for D2 (Intel) v.9.17 - 9.17.10.2828,Method to Download SONY VGN-CR290N Realtek High Definition Audio Driver v.5.10.0.5433,Download SONY VGN-FS710/W Utilities DLL Update v.6.4.0.06290 driver,Method to Update & Download SONY VGN-NR460E/P Intel Graphics Media Accelerator Driver v.6.14.10.4847,How to Fix Error 0x0000c1f5 Solución?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error,Solution to ashoutxt.dll Missing Error,Solution to cxcore096.dll Missing Error,Where can I Find dsauth.dll File,How to Fix msde.dll Not Found Error,Best Method to Fix psizewizres.dll Error
Read More: How Can You Fix - Delivery status notification -delay Hotmail with Windows 7?,Solution to Error: Debug a service!,Troubleshooter of Error: Dell popup will not go away?,How to Fix - decimal places in formula?,Delete selected image in Word 2007,Data validation question. Maintaining and updating named ranges.,Desktop Gadget Gallery on Windows 7,delete empty rows,Deleting a page and also how can I copy an exact page lay out on a new page,Date Formula for 1st Sunday of each Month (3rd to 9th)
by fixappcrash | 2016-09-27 12:10