| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
appending fields from another spreadsheet
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.)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
appending fields from another spreadsheet
Could you post a sample of what the data looks like in each worksheet.
Regards, OssieMac "eliyahuz" wrote: 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.)? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
appending fields from another spreadsheet
How do I do that?
"OssieMac" wrote: Could you post a sample of what the data looks like in each worksheet. Regards, OssieMac "eliyahuz" wrote: 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.)? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
appending fields from another spreadsheet
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 "eliyahuz" wrote: How do I do that? "OssieMac" wrote: Could you post a sample of what the data looks like in each worksheet. Regards, OssieMac "eliyahuz" wrote: 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.)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create the angled fields above a spreadsheet for titles? | New Users to Excel | |||
| Excel Spreadsheet - Mandatory fields | Excel Worksheet Functions | |||
| How can I fill in the required fields on my spreadsheet? | Excel Discussion (Misc queries) | |||
| Appending data from one spreadsheet to another using a macro | Excel Discussion (Misc queries) | |||
| Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
Linear Mode
