Thx for the answer.



But I'm not sure Excel will able to fill that role. The helping sheet I'm working on will have a lot of graphic, Header, Footer etc.

On the other hand, I've envountered auto-filling field in Word and I think it'll do the job. I'm just not quite sure how they work.

Also, is there anything that we can do to force Word to print a specific sheet in the back of all the 100 pages? (Let's say I got a document of 101 page. I would like to print the first 100 on the front of 100 sheet. And I want to print the 101th page on the page on the "back" of all 100 sheet).

Oh yeah, and don't hesitate to show me complex stuff. I'm at ease with Office and VBA

Hi
There is nothing stopping you putting graphics and headers/footers in Excel.
I will have a think about your other issue about printing the same page on the back of every sheet and get back to you via the forum.
Tony