Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Any (clever) way to automate ROW:COL in copy/paste??? | Excel Worksheet Functions | |||
automate a cut and paste of data from one work book to another | Excel Discussion (Misc queries) | |||
I wish automate a cut and paste of data from one work book to ano | Excel Worksheet Functions | |||
Automate cut/paste functions - Help! | Excel Discussion (Misc queries) | |||
HELP....Is there a way to automate copy/paste special/transpose - | Excel Worksheet Functions |