Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i use form/skjema tool for meny list spred in dif arks | Excel Worksheet Functions | |||
Combine data | Excel Discussion (Misc queries) | |||
Combine data - Please help | Excel Worksheet Functions | |||
Need to combine and add data | Excel Discussion (Misc queries) | |||
Combine Data | Excel Discussion (Misc queries) |