Macro to transpose data from Excel to Word

Hello! I'm an intern at a company and I need help with a problem I'm having.

I need to create a macro to copy a row of cells from an Excel spreadsheet to a Word template.

Ideally, the macro would work like this.

1. The user highlights a row of cells.
2. The row of data has cells that fall under different categories defined by the columns they are in.
3. The macro would then paste the cells to corresponding locations in the Word template.

Can anyone give me an example on how to do this?
Or link me to some literature that can help me?

Thank you in advance. I would appreciate any help greatly.

I have attached examples for reference.

Thanks any help is greatly appreciated!

Hello Wendy_The_Intern_<3,

Welcome to the Forum!

Can you provide a list that shows which column on Sheet1 corresponds to which label in the Word document?

Hello Leith!

Thank you so much for helping me! You don't know how much I appreciate it

Column A --> !JOB
Column B --> !SHIPPER
Column C--> !DATECREATED
Column D--> !CUSTOMER
Column E--> !FANALYST
Column F--> !COUNT
Column G--> N/A (Not Applicable)
Column H--> !DEVNUM
Column I--> !LOT
Column J--> N/A
Column K-->!DATECOMPLETE
Column L--> N/A (Not Applicable)

Thank you! You're great!

Btw, I updated the attachments so be sure you open the new ones! Thanks!

Hello Wndy,

You have this field !PARTTYPEs in the Word document but I don't see a column for it on the Excel worksheet. Should I ignore it?

EDIT: These fields are missing in excel also - !WORDNUM and !HOURS

See the attachments

copy te worddocument to your own location. you have to adapt the code to find it (see below)

Open the Excel Workbook
Select a cell in a certain row you want to be transpoerted en run the macro:

Before running the macro you have to change "E:\OF\" in the macro by the path wheree de Worddocument is located.

Please Login or Register  to view this content.

Hello Libby,

If you can provide me with answers to my previous post then I can finish the macro for you.

I hope you did realise that the result will be saved in the document 'form 001.doc'

In the attachment a workbook in which you won't need to change anything, provided you store this workbook in the same folder as that containing the worddocument.
You only have to run the macro:

Please Login or Register  to view this content.

@wendy

It's not necessary to select a row. You can select any cell (only 1) in a row and run the macro.

In the Word document Menubar/insert/fields/select docvariable/enter a variable name

Alternative method:

ctrl-F9; now two accolades { } appear.
Type between the accolades DOCVARIABLE name
the result : {DOCVARIABLE name}

'name' is the name of the variable; you can chose any name, as long as you don't use spaces; if you do you need to hyphenate the name like:t "new name"
You can only attribute a value to a docvariable using VBA.
You can toggle the 'visibility' of this field using te toggle button Alt-F9.