I need to link 2 excel files. Let's call them file 1 and file 2
I need to insert rows in file 1 so that it inserts the same amount of rows
in the same position in file 2.

Ben,

Whenever I see a question like this, I have to ask: Why? Why not just use
one file with one sheet? Any other approach will have potential problems,
and require a lot of work to design.

HTH,
Bernie
MS Excel MVP

"Ben" wrote in message
...
I need to link 2 excel files. Let's call them file 1 and file 2
I need to insert rows in file 1 so that it inserts the same amount of rows
in the same position in file 2.