Yes, this does sound tricky. The code could be an Excel macro. You'd put the cursor (as you say) on the left most cell and engage the macro. It would copy the cells of that row (Ax - Ex), then it would move over to Word and paste the values in "transposed" form, each cell's value occupying a separate line.
The tricky issue is "How do you get VBA code in Excel to continue doing stuff once it has moved over to the Word application?", where the object commands are different.
For me, I don't know how to do this.
So, I considered a more manual approach. This isn't exactly what you want, but it works almost as good:
1) Manually select the Excel cells that you want to copy (either just cells Ax-Ex, or the whole row if no cells right of column-E are populated). Copy selection to the clipboard (via 'Cntrl-C').
2) Manually move to the desired Word file and manully put cursor at desired insertion point.
3) Invoke the following macro via your desired shortcut key-combination. I have included comments on each line to explain each line's purpose. The macro results with the text in the format that you prescribed.
Excluding the manual selection of the Excel cells and the manual move to Word and manually positioning the cursor in Word, at least the harder part of parsing the table cells up into separate left-justified paragraphs is automated. I hope this gets you a step closer to your needs!
A possible variant idea: You could build another, fairly simple macro in the Excel file (with a similar shortcut key combo) that automates the Excel portion of the above tasks: 1) copying the selected cells and 2) moving over to the Word application. Then, you'd only have to manually position the cursor in Word followed by invoking the following macro. ... Regards, sauerj
Bookmarks