How to extract specific data from Excel and paste it in Word

[smarinaj]

Hi!

I would like to request your help creating a macro to grab specific data from an Excel document and paste it into a Word document.

This is my dilemma:

I have a long 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. Each Word document already contains a populated table with two columns.

I want the macro to look in each row of the Excel document to find a word 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.

After that, I would like to do the same thing with letter "B", "C", etc.

Any suggestions would be greatly appreciated.

Thanks so much.

Sandra <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->