Merge data from 2 Excel worksheets

OS Win Xp SP2, Excel 2004 SP1
I have 2 different types of excel spreadsheets, a company spreadsheet
and a contact spreadsheet.
The company database has an address field and the contact database
does not.

I'd like to compare both databases on the company field and add the
address elements of Address, city, state and zip to the contact
database.

I am not a programmer, but can follow an example or directions to do
this.

TIA
Bob

Hi

you don't actually need to use code for this, the VLOOKUP function can be
used instead

assume the company sheet is set up as follows
.........A.............B....................C..........D..........E
1....Company...Address.........City....State......Zip
2....ABC.........15 North Rd...Perth...WA......6000

and the contact one is set up as follows
.........A.............B..............C..........D..........E..........F
1....Company...Contact...Address...City......State.....Zip
2....ABC...........Fred....................................................

the formula for contact sheet C2 would be
=VLOOKUP(A2,Company!$A$2:$E$1000,2,0)

the formula for contact sheet D2 would be
=VLOOKUP(A2,Company!$A$2:$C$1000,3,0)
the formula for contact sheet E2 would be
=VLOOKUP(A2,Company!$A$2:$E$1000,4,0)
the formula for contact sheet F2 would be
=VLOOKUP(A2,Company!$A$2:$C$1000,5,0)


you could then select these cells and fill down (select the cells and
then move your mouse over the bottom right hand corner of F2 and when you
see a + double click)

Hope this helps
Cheers
JulieD



<[email protected]> wrote in message
news:[email protected]...
> OS Win Xp SP2, Excel 2004 SP1
> I have 2 different types of excel spreadsheets, a company spreadsheet
> and a contact spreadsheet.
> The company database has an address field and the contact database
> does not.
>
> I'd like to compare both databases on the company field and add the
> address elements of Address, city, state and zip to the contact
> database.
>
> I am not a programmer, but can follow an example or directions to do
> this.
>
> TIA
> Bob
>

Thanks Julie, i'll give it a try.
Bob
On Sat, 12 Mar 2005 00:48:34 +0800, "JulieD"
<[email protected]> wrote:

>nt types of excel spreadsheets, a company spreadsheet
>> and a contact s