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?
|