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 K-->!DATECOMPLETE
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!

What would trigger the macro. Do you have a button or something to do that?

Anyways here is one solution to your problem (http://vbadud.blogspot.com/2009/08/u...ith-excel.html)

Have bookmarks in the Template where you want the information to be used and use the snippet

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Good Afternoon I need assistance with a Macro for Excel.
After many video's and screening websites I still do not have the right answer!

I work for a property company and came up with an idea.
We have a excel template our managers fill in with relevant data for each tenant for us to Draft a offer.

I need a macro to move data for example from cell C4:D4 (Called "Tenants name") to my bookmark in word called Lessee_name. And replace it the tenants name.

Everytime I paste the macro off forums etc it gives me an error. If this works I would then update the macro to insert the tenants other details and have it update automatically everytime I receive a excel template for the different tenant.

This is much appreciated.