how do i link 2 excel files?

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" <Ben@discussions.microsoft.com> wrote in message
news:2FCEF568-0D45-48CB-B956-98A883EE81CD@microsoft.com...
>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.