How can I get linked data to update inserted rows

J

Jean-Toledo

I have two workbooks that are linked. If I add a row in my source workbook
and update the link in my destination workbook, the new row does not show up.
(I will need to be able to see new columns added to the source as well) Is
there a way to paste link and update these types of structure changes?
 
G

Gord Dibben

Same answer as over in the programming group.

You will need VBA to automatically insert the rows/columns into the target
workbook.


Gord Dibben MS Excel MVP
 
Top