Extract SPECIFIC data from Excel and Paste it in a Word Table

**smarinaj** · 03-04-2011, 12:25 PM

Good morning,

I would like to create a macro that helps me accomplish the following:

I have an Excel document with two columns, one for the terms in English and one for the translation into Spanish.

I have a word document for each letter of the alphabet. For instance, one document is A.doc, another is B.doc, etc. The word document already contains a populated table with two columns.

I want the macro to look in each row of the Excel document starting with an "A" in the first column and paste the content of the entire row into the word document named "A.doc", at the end of the table, without deleting other rows in the existing Word table.

Any suggestions, please?

Thanks so much.

Sandra

**Leith Ross** · 03-04-2011, 02:21 PM

Hello Sandra,

Welcome to the Forum1

To help provide you with possible solutions, you will need to attach copies of both the Excel worksheet and a Word document.

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

To Attach a File:

Scroll down to the window below your post Additional Options
In the frame Attach Files you will see the button Manage Attachments
Click the button.
A new window will open titled Manage Attachments - Excel Forum.
Click the Browse... button to locate your file for uploading.
This will open a new window File Upload.
Once you have located the file to upload click the Open button. This window will close.
You are now back in the Manage Attachments - Excel Forum window.
Click the Upload button and wait until the file has uploaded.
Close the window and then click Submit.

**smarinaj** · 03-04-2011, 02:59 PM

Hi Leigh, I am sorry but I don't find the Post Reply button you mentioned in your message. I would like to upload my files, but I don't see how. Please help!

**Leith Ross** · 03-04-2011, 03:15 PM

Hello smarinaj,

See if this helps...

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'.
Clicking this button will open a new window for uploading attachments.

You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file.

To upload a file from another URL, enter the full URL for the file in the second box on this page.
Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.