P
PSea
I have an address worksheet that has a column for the dealer code, name and 3 separate columents for address fields. My second worksheet has a column for the dealer code, name and other information in columns. I need to add the address fields from the 1st file to the 2nd file.
Complications:
- There are names on the 2nd worksheet that are not on the 1st address sheet, and vice versa.
- There are multiple names for a single dealer code on both worksheets, but not necessarily the same ones.
- To make it even more interesting, there can be multiple versions of an address for a single dealer code.
- And, to top it off, a name may appear at an alternate dealer code if it does not appear for the first one you come to
I'd like to be able to deal with all the variations if possible. Is there a way to try to
(A) associate the dealer codes so that I can pull the addresses from one worksheet into the othe
(B) look at the name to see which version of the address to us
(c) if the name in the 2nd worksheet does not appear for that dealer code in the first worksheet look farther down the worksheet to see if it appear there
If that's not possible, is there a way to associate the dealer codes so that I can pull the 1st address for that dealer code into the other worksheet
Love to hear any ideas. Please e-mail me directly or post here. Thanks.
Complications:
- There are names on the 2nd worksheet that are not on the 1st address sheet, and vice versa.
- There are multiple names for a single dealer code on both worksheets, but not necessarily the same ones.
- To make it even more interesting, there can be multiple versions of an address for a single dealer code.
- And, to top it off, a name may appear at an alternate dealer code if it does not appear for the first one you come to
I'd like to be able to deal with all the variations if possible. Is there a way to try to
(A) associate the dealer codes so that I can pull the addresses from one worksheet into the othe
(B) look at the name to see which version of the address to us
(c) if the name in the 2nd worksheet does not appear for that dealer code in the first worksheet look farther down the worksheet to see if it appear there
If that's not possible, is there a way to associate the dealer codes so that I can pull the 1st address for that dealer code into the other worksheet
Love to hear any ideas. Please e-mail me directly or post here. Thanks.