Inserting rows after Paste Linking

[Guest]

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?

 

[Guest]

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.

 

[Guest]

I will give it a try - thanks.

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.