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