EXCEL print page with sequentional number

May 16, 2009 at 04:46:42
Specs: Windows Vista
Hi!

I need some help, need to print 99 daily reports, they are all the same, except for the number of the report, from 0 to 99.

I have the excel page centered and ready to print, so the page setup is complete, and the print comes out the way i need.

The problem is that i need something to automaticly print these 99 reports sequentialy inserting the numbers on ## from 0 to 99, on the page cell that has the text " daily report number ## "

It seems to me that i could use a macro, but i dont know hot to work with macros.

can u help me?

thanks a lot

Daniel


See More: EXCEL print page with sequentional number

Report •


#1
May 16, 2009 at 08:16:55
Would not a custom Header/Footer be simpler and serve your purpose?
Or am I missing something?

MIKE

http://www.skeptic.com/


Report •

#2
May 16, 2009 at 09:22:37
thanks Mike,

a header or a footer would do that, the problem is that, this report has a specific design and the numbering must be inside the report, located in the middle.

I relly need to number a specific cell, automaticly when printed. this numbering cant be located neither on the top nor in the end of the page. must be inside onde cell..

thank you though.


Report •

#3
May 16, 2009 at 09:38:37
Sounds like something that you would need a VBA for.
Unfortunately, my VBA skills are just above nil.
Perhaps someone else can offer assistance.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
May 16, 2009 at 09:58:26
I found this and it seems to be what your looking for:

http://www.dailydoseofexcel.com/arc...

It uses "Defined Names"

I haven't tried to print, but it will give you the "page # of # pages" within a cell.
Just modify the "Pageofpages" defined name to suit your needs.

MIKE

http://www.skeptic.com/


Report •


Ask Question