How to serialize document copies in MS Excel / Open Office Calc?

I need help with a printing problem. I’m using Microsoft Excel / Open Office Calc. I have a page that I want to print. I want to print multiple copies of this page. On each page, I want it numbered so I can keep track of the individual copies. For example, say I want three (3) copies of a page. I want them numbered “Copy 1”, “Copy 2”, and “Copy 3”. Does anyone know how to do this without replicating the page?

I can’t try it here since I don’t have a printer attached, but OpenOffice (and Excel too, IIRC) has a macro recorder that might work. Start the recorder, set a cell to “Copy 1”, then File | Print, change the cell to “Copy 2”, File | Print, and so on. End the recording and then run the macro. Try with only two or three copies of a little dummy sheet to start.

(A more flexible way would be to write a loop that will go around as many times as the value in some cell, printing a copy with each pass, but I’ll leave that for someone else.)

I don’t think there is any easy way to do this except with a macro.