Transferring Excel fields into Word document

Occasional Visitor

I have an excel spreadsheet where i work out my quotation data. I have been then copying and pasting the different totals for each line of the quote into a Word document. I am trying to get tht code right to transfer each individual field into different parts of the word doc with one click instead of manually copying each one. There are 10 to 20 lines with $amounts that i want to transfer to my word template

In Excel I have

Qty 50

Components 40

Hardware 130

Panel 375

NRE 850


And then in my Word document  I have

PCB Cost

USD Exchange Total


Can anyone please help me figure out how i can get the numbers from excel into the correct lines in word?

2 Replies



are you using this in Excel online? Then you can't use macros or VBA. If you use Excel and Word for desktop, you can use VBA code, but it's not trivial to set up.


Basically, you need to create bookmarks in the Word document, then in the Excel code, open the Word document, jump to the bookmark and insert the value from the Excel cell. How exactly that code needs to be written depends a lot on your Excel and Word data structure.



Hi I think this video I have created might just help you out on having Data from Excel into Word:


Learn How To Format Data In Word & Excel With My New video here: https://youtu.be/c4WvVG6zESg 🔥 Join thousands in my amazing Single Click Dashboard Reports Masterclass Here: http://bit.ly/Excel_Dashboard_Masterclass 💯 Get 100 Of My Best Workbooks in One Zip File Here: http://bit.ly/100_Workbook...
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies