I have a dataset in Excel which is only about 1,000 rows. It consists of
information on about 250 employees. COlumns include personal data like name,
address, SSN, etc., along with specific detail for each selected from up to
12 different categories, and ending with a currency total.

I DLed the Sales Template and hacked it to fit my needs for presentation.
Then I wrote a macro which gathers the data from the main WS and converts it
into a set of variables with which I populate the template. So far, so good.
However, once I have populated the template with the data I need to put a
pagebreak and have an empty copy of the template present for the next
employee's set of data.

Anyone out there able to tell me how to do this?
--
Dave
Temping with Staffmark
in Rock Hill, SC