Automate Cut & Paste
 

I have a query that pulls information from various access tables and then a
report is generated in excel by rep name. Is it possible for each rep to
have their own excel file? As of now I cut and paste each reps information
to a separate excel file and then email that information as an attachment to
them...this job is performed weekly. Can you offer any advice in order to
expedite the process?

Thanks.

Automate Cut & Paste
 

Do you mean all of the info is dumped into one worksheet, and you want
to separate it by name into different workbooks. Ron De Bruin has some
code that let's you separate a worksheet into separate workbooks
depending on a field filter. Check out his site http://www.rondebruin.nl.

HTH,
JP

On Sep 12, 10:25*am, jlo wrote:
I have a query that pulls information from various access tables and then a
report is generated in excel by rep name. *Is it possible for each rep to
have their own excel file? *As of now I cut and paste each reps information
to a separate excel file and then email that information as an attachment to
them...this job is performed weekly. *Can you offer any advice in order to
expedite the process?

Thanks.

Automate Cut & Paste
 

Thank you.

"JP" wrote:

Do you mean all of the info is dumped into one worksheet, and you want
to separate it by name into different workbooks. Ron De Bruin has some
code that let's you separate a worksheet into separate workbooks
depending on a field filter. Check out his site http://www.rondebruin.nl.

HTH,
JP

On Sep 12, 10:25 am, jlo wrote:
I have a query that pulls information from various access tables and then a
report is generated in excel by rep name. Is it possible for each rep to
have their own excel file? As of now I cut and paste each reps information
to a separate excel file and then email that information as an attachment to
them...this job is performed weekly. Can you offer any advice in order to
expedite the process?

Thanks.