Trying to pull data from multiple sheets (and Word docs too)

S

ShaunRichard

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.
 
S

ShaunRichard

By the way, I forgot to mention I am running Office 2003 with Vista. Thanks
again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best Way to Pull Data from Other Sheets 6
Pull info from multiple worksheets into one Master 2
Pull Data from multiple sheets 1
pulling info from multiple sheets 2
Making an e-mail list from Excel data 2
Transfer data from Word docs into Access? 12
Let User Select Sheet to Pull Data From 7
Sumary of 150 sheets info in one sheet 3

Top