Inserting rows after Paste Linking
 

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?

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?

Inserting rows after Paste Linking
 

I will give it a try - thanks.

"Jim Jackson" wrote:

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?