View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Jackson Jim Jackson is offline
external usenet poster
 
Posts: 324
Default Inserting rows after Paste Linking

Someone else may have a better answer.

You can place a command button on the source sheet with code to open the
linked workbook, copy the first linked row and paste down however many rows
are necessary. Or you could place a Sub Auto_Open() macro in the linked
workbook to do the same thing automatically when opened.
--
Best wishes,

Jim


"Jean-Toledo" wrote:

I have two workbooks that are linked. When I insert a row in the source
workbook and add data (in the middle of the originally selected rows), the
new row doesn't show up in the destination/linked workbook. How do I get
paste link to add these addtional rows to the destination workbook?