Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Careful mergin of data
I'm sure there's an easier way to do what I'm doing and wanted to ask for
suggestions: I have an address list on Excel of about 900 addresses. I just received a version with about 300 of the addresses changed. I don't want to change any of the other columns of data. So, I'm manually cutting and pasting the new addresses in. Is there an easier or automatic way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Careful mergin of data
On 4 Feb, 16:28, David in VB
wrote: I'm sure there's an easier way to do what I'm doing and wanted to ask for suggestions: I have an address list on Excel of about 900 addresses. *I just received a version with about 300 of the addresses changed. *I don't want to change any of the other columns of data. *So, I'm manually cutting and pasting the new addresses in. *Is there an easier or automatic way to do this? This sort of job is a pain. What do you have that ties together the two batches of addresses? Are there any names or postcodes/zipcodes in common? Joe. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Careful mergin of data
Joe,
I sure do. Each person has an account number. This account number appears in the old table as well as the new one that holds the updated addresses. Is there a way to link that way? "Joe Murphy" wrote: On 4 Feb, 16:28, David in VB wrote: I'm sure there's an easier way to do what I'm doing and wanted to ask for suggestions: I have an address list on Excel of about 900 addresses. I just received a version with about 300 of the addresses changed. I don't want to change any of the other columns of data. So, I'm manually cutting and pasting the new addresses in. Is there an easier or automatic way to do this? This sort of job is a pain. What do you have that ties together the two batches of addresses? Are there any names or postcodes/zipcodes in common? Joe. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BE-CAREFUL, YOU COULD BE A VICTIM OF SCAM OR FRAUD!!! | Setting up and Configuration of Excel | |||
BE-CAREFUL, YOU COULD BE A VICTIM OF SCAM OR FRAUD!!! | New Users to Excel | |||
BE-CAREFUL, YOU COULD BE A VICTIM OF SCAM OR FRAUD!!! | Excel Discussion (Misc queries) | |||
BE-CAREFUL, YOU COULD BE A VICTIM OF SCAM OR FRAUD!!! | Links and Linking in Excel |