Hi,

How can I make one workbook which links to another workbook
automatically create a row, when a row is inserted in the workbook,
which is being linked to.

Furthermore I would like the workbook with the links to automatically
update those links, so they still fit.

This might be a little tricky formulated, so I will make an example:

Workbook A links to Workbook B.

workbook A A1=workbook B A1
workbook A A2=workbook B A2

Quite simple really.

If I insert a row between A1 and A2, I would like workbook A to
automatically (or through a macro) be able to change similarly.

I can make a macro, where I insert a row in both workbooks and update
the formula, but that macro has to insert the row at a given place,
since I dont know how to prompt and make the macro ask for a specific
row.

A macro with a prompt would be fine, but does anyone know how to solve
this one?


Thx. Lars


--
50pingviner
------------------------------------------------------------------------
50pingviner's Profile: http://www.excelforum.com/member.php...o&userid=29298
View this thread: http://www.excelforum.com/showthread...hreadid=495440