View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scr scr is offline
external usenet poster
 
Posts: 10
Default Replacing information from one doc to another if conditions apply

I have an original list of addresses. A "reroute" list is provided. If
columns A, B, & C on the original list match columns A, B, & C on the
"reroute" list the addresses in columns D, E, F, G & H must be changed to
the new addresses listed on the "reroute" list columns D, E, F, G & H.

If, however, there is not match then the address in the original list needs
to stay the same.

Any suggestions?