View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ShaunRichard ShaunRichard is offline
external usenet poster
 
Posts: 2
Default Trying to pull data from multiple sheets (and Word docs too)

Not sure if this can be done. I have a list of clients in an Excel worksheet,
which includes contact name, address, and phone info, but no e-mail
addresses. I have several individual order sheets for the same clients in
both Excel and Word format that contain e-mail addresses. Is there any way I
can pull in the e-mail addresses from the individual sheets and documents
into a new column in the client info worksheet on the corresponding row with
the existing information?

Thanks for any info you might provide.