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.
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 L--> N/A (Not Applicable)
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!