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