Excel question - putting 2 sheets into a 3rd one.

[MasterD_Evil]

Ok, not sure if anybody can help, but here's the (odd) question in an example form:

Imagine having 2 excel documents, named 1.xls and 2.xls.

In 1.xls you got 1 colum saying "name" and a second one saying "telephone number."

In 2.xls you got 1 colum saying "name" and a second one saying "residence."

How do I make 3.xls that automatically gives the first colum "name", the second colum "telephone number" and a third colum "residence."
All this based on 1.xls and 2.xls

Thanks if you bothered to read or can tell me how to do this.

[DiabloRex]

This is translated from a danish version of office, so the names might not be the same, keep that in mind

Edit -> insert special -> insert chain.

This is some time ago I did this, so its probably not right, but I do seem to recall that its there the function is

First you need to copy those cells from x1 and x2 you want to use in x3

[Joffar]

iirc correctly you have to give the cells unique names and refer to them in the third document

[Silmarillion]

Okay, maybe I'm being very ignorant here, but can't you just copy and paste the columns you want from 1 and 2 into 3 ?

I use Excel, but not very often.

[DiabloRex]

Sil, he can do that but I think he wants the number changed in x3 if he changes them in x1. You can do that by making a chain thingy