Automate Cut & Paste

J

jlo

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.
 
J

JP

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
 
J

jlo

Thank you.

JP said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cut & Paste in Excel without erasing cell borders? 1
How do I email individual tabs in a workbook? 1
loop through code and refernce text file for info 1
NEED HELP! Macro loop 7
Add Sales Goals to Sales Report in Pivot Table 1
Access 2002 Data entry combo box or list box 3
Excel - cut and paste 3
Disable Cut/Copy/Paste in Excel 2010 0

Top