It has a .xls file name, so I'm guessing a normal workbook. It has 2
worksheets: "paysheet" (the one I want to paste the data to) and another
one, which is used to help calculate a pivot table that is contained within
"paysheet"

"Ron de Bruin" wrote:

Hi richzip

Is it a normal workbook the template or a real template workbook (xlt)


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"richzip" wrote in message ...
Hi there ..thank you so much for your help. I have a couple of other
questions:

I probalby won't use the mail thing you mentioned, since names are not on
the source workbook. However, copying the data to a new work book will be
very helpful.

I used the section titled "Create a new workbook for all unique values" and
it worked great. however, I want the source data to be copied to a
"template" in a totally separate workbook,that I already have saved in "my
document". that template has its own header row, and I want to paste the
data to the row right below that header (row 3).

Should I modify the "Create a new workbook for all unique values" or the Add
data to an existing sheet (AutoFilter))" instructions? If so, what needs to
be modified?

Thanks again!!


"Ron de Bruin" wrote:

Hi

Maybe in one step (with mail code)
http://www.rondebruin.nl/mail/folder3/row2.htm

See also this page
http://www.rondebruin.nl/copy5.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"richzip" wrote in message ...
I want to know if it is possible to do the following:

I have a worksheet with hours worked for approx 400 employees. As employees
request a look at their hours, I copy their individual data into a template,
which I then email to them. The template has a small pivot table, which I
have set up to auto-refresh as data in the cells is changed. I want to try
to automate this process as much as possible:

I want to copy the rows for an employee into this template (using "paste
special" and "values" only, to preserve the formatting of this template).
The selected rows would depend on the employee number, which is the first
column of the main workbook. Then I want to save it with the employee number
as the file name. Then, it would repeat this process for each employee.
Each employee's data would have to be copied into the "blank" template before
saving, since some employees might have fewer rows than the previous
employee.