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!
Bookmarks