Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically copy data from large worksheet into individual workb
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
Automatically copy data from one worksheet to another | Excel Worksheet Functions | |||
Copy data automatically onto a separate worksheet | Excel Discussion (Misc queries) | |||
Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
automatically copy data from one worksheet to another | Excel Worksheet Functions |