Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Blank rows after every row upto 2500 rows | Excel Worksheet Functions | |||
Inserting a button into a cell and linking it to a macro | Excel Discussion (Misc queries) | |||
linking sheets and inserting lines | Excel Discussion (Misc queries) | |||
Inserting multiple rows in excel with data in consecutive rows | Excel Programming | |||
Inserting Photos into Excel and linking to Word. | Excel Discussion (Misc queries) |