View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RobcPettit[_2_] RobcPettit[_2_] is offline
external usenet poster
 
Posts: 108
Default predisigned table

Hi, I was wondering if there was something simular to autotext in
excel. In word Ive saved a table layout and inser when needed. In
excel I have the same table layout which I copy and paste when I need
another table. What Im doing is on sheet1 I have my table 20col by 40
rows. I like to repeat the table underneath eah table on the sheet. I
dont want to use a new sheet. I have a macro that copys and pastes
these for me. I have to keep the original on a sepperate sheet to copy
from so theres no data. Hope this is clear
Regards Robert