appending fields from another spreadsheet

E

eliyahuz

I am halfway through a spreadsheet that I want to use to merge to Word from.
In the middle I realized that I need address information for each record. I
want to get the address information from another spreadsheet previoiusly
created. The spreadsheet I am working on contains a first and Last name
field. Is there a way to get the address information added to the new
spreadsheet (first and last name only) from the old one (first,last,address,
etc.)?
 
O

OssieMac

Could you post a sample of what the data looks like in each worksheet.

Regards,

OssieMac
 
O

OssieMac

I just want to know what a record looks like in each sheet. Is it like this:-

Myfirstname Mysecondname

or like this:-

Myfirstname
Mysecondname

and similarly I'd like to know how the records are assembled in the address
sheet.

I don't understand how the data needs to be manipulated. It also intrigues
me as to why not just use the old spreadsheet if it already has all the data.

Regards,

OssieMac
 
Top