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

without fully understanding your explanation, I would guess that you should
make a copy of the blank template before you begin filling it in. Do this
each time, so that when you begin filling in, you have two blank templates -
one of which gets filled in.

--
Regards,
Tom Ogilvy


"Dave Birley" wrote:

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

Unfortunately the project was thrown at me with less than 2 hours to get out
the result -- your answer is, of course, exactly what I should do. Dang <g!

Just curious, though, should I save the template with a pagebreak at some
arbitrary Row number on a separate WS, then copy those rows from there into
the "main" WS? It would seem to me that if I did, then the offset to the
fields in each new template would always increment by the same number of rows.

As I say, the task is past now, but my personal learning curve continues <g!
--
Dave
Temping with Staffmark
in Rock Hill, SC


"Tom Ogilvy" wrote:

without fully understanding your explanation, I would guess that you should
make a copy of the blank template before you begin filling it in. Do this
each time, so that when you begin filling in, you have two blank templates -
one of which gets filled in.

--
Regards,
Tom Ogilvy


"Dave Birley" wrote:

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