i wonder if i could show you the template. basically it has seven columns
with dates. i only have one sheet and have to change the date for each
monday and reprint for each week. i was hoping i could only print once and
then it will automtically print all 52 weeks.

"ryguy7272" wrote:

So you have 7 rows on each sheet and 52 sheets? If I were you, I'd collate
everything on one summary sheet and filter your data there. Check this out:
http://www.rondebruin.nl/summary.htm

Also, this:
http://www.rondebruin.nl/copy2.htm

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"SSADA" wrote:

I have one template that i print for our production floor. Each sheet has
seven dates printed; Monday thru Sunday. I need to print this one template
52 times for each week of the year. Is there a formula that i could enter
one day (i.e. the first date for the first monday) and automtically print the
rest of the weeks. in essence, press the print button one time, but the same
template will print 52 times with each week on the sheet?