Combine two data arks?
 

Hi,

I'm very new to VB in excel so please bare with me.
(have read the http://www.mvps.org/dmcritchie/excel/getstarted.htm)

I have two data arks with a lot of informations on customers:

Ark one:

Customername, Email, company

Ark two:

Cusomername, phone, address, zip... etc.

Now I want to combine the two arks to one - I mean, search one coloumn for
the customername, if true then copy the address to the first ark (or make a
new with the results)

Would that be possible on some sort of easy way?

Thanks in advanced.

/Brian

Combine two data arks?
 

Why VBA? Why not use a VLookup Formula?
--
HTH...

Jim Thomlinson


"blacker" wrote:

Hi,

I'm very new to VB in excel so please bare with me.
(have read the http://www.mvps.org/dmcritchie/excel/getstarted.htm)

I have two data arks with a lot of informations on customers:

Ark one:

Customername, Email, company

Ark two:

Cusomername, phone, address, zip... etc.

Now I want to combine the two arks to one - I mean, search one coloumn for
the customername, if true then copy the address to the first ark (or make a
new with the results)

Would that be possible on some sort of easy way?

Thanks in advanced.

/Brian

Combine two data arks?
 

Could you give an example of how?

/Brian

"Jim Thomlinson" skrev i en
meddelelse ...
Why VBA? Why not use a VLookup Formula?
--
HTH...

Jim Thomlinson


"blacker" wrote:

Hi,

I'm very new to VB in excel so please bare with me.
(have read the http://www.mvps.org/dmcritchie/excel/getstarted.htm)

I have two data arks with a lot of informations on customers:

Ark one:

Customername, Email, company

Ark two:

Cusomername, phone, address, zip... etc.

Now I want to combine the two arks to one - I mean, search one coloumn
for
the customername, if true then copy the address to the first ark (or make
a
new with the results)

Would that be possible on some sort of easy way?

Thanks in advanced.

/Brian