Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat a task
I have an output file that is the same format generated automatically
everyday from a system. It is in the same format and the same length everyday. What I need to do is be able create an easy way to point to the file, have it copy the correct range and place it at the end of the master file. Any idea? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat a task
Turn on the macro recorder and go through the steps.
If you need help with the generated code post back. You will probably want to ascertain the range to copy to. The recorder will give you a set cell address which you may not want since you are appending to an existing range. Give us a few details and we'll assist with getting the last used row. Gord Dibben MS Excel MVP On Fri, 12 Mar 2010 13:24:01 -0800, Paul wrote: I have an output file that is the same format generated automatically everyday from a system. It is in the same format and the same length everyday. What I need to do is be able create an easy way to point to the file, have it copy the correct range and place it at the end of the master file. Any idea? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help on a task | New Users to Excel | |||
First ever task | Excel Discussion (Misc queries) | |||
how to repeat rows at the bottom while using the rows repeat at to | Setting up and Configuration of Excel | |||
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
How repeat a task on all files on a floppy drive | Excel Discussion (Misc queries) |