preset table
 

Is it possible to have a table saved and insert when needed on the
same sheet. Im thinking something simular to autotext in word as I do
this. At the moment I copy and paste using a macro.
Regards Robert

preset table
 

No method of saving a table and autotexting as you suggest.


Gord Dibben MS Excel MVP

On Fri, 17 Oct 2008 15:10:04 -0700 (PDT), RobcPettit
wrote:

Is it possible to have a table saved and insert when needed on the
same sheet. Im thinking something simular to autotext in word as I do
this. At the moment I copy and paste using a macro.
Regards Robert

preset table
 

Hi,

Do you always want to insert the same table in the same sheet? Or do you
want to insert a sheet with a predesigned table into any workbook? Do you
always want to insert the table into the same file?

--
Thanks,
Shane Devenshire


"RobcPettit" wrote:

Is it possible to have a table saved and insert when needed on the
same sheet. Im thinking something simular to autotext in word as I do
this. At the moment I copy and paste using a macro.
Regards Robert