macro to transfer data from excel to specific text boxes in word

[duckie123]

Hi Everyone,
I am have an excel spreadsheet with two columns of data. I would like to transfer that data into text boxes that I have lined down the page in word. I was wondering if this is possible. Any kind of help would be greatly appreciated. thank you.

<table width="136" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 54pt;" width="72"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" width="64" height="20">Color</td> <td style="width: 54pt;" width="72">Frequency</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Red</td> <td align="right">66</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Blue</td> <td align="right">43</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Green</td> <td align="right">34</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">Gray
</td> <td align="right">93
</td> </tr> </tbody></table>

 

[Trevor G]

This is a duplicate thread, please stick to one thread

 

[Peter_SSs]

Duplicate to http://www.mrexcel.com/forum/showthread.php?t=542089

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.