ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Word doc from Excel using a macro? (https://www.excelbanter.com/excel-programming/421671-word-doc-excel-using-macro.html)

Kesbutler

Word doc from Excel using a macro?
 
I have an Excel file that contains headings that are used to create a word
doc for a training manual. Is there a way I can either auto populate the
Excel headings into Word or select what headings I need and create a macro
that would generate a word doc to populate with text?

Example:

A B C D
1 Title Heading 1 Heading 2 Heading 3
2 Training Topic A Sub-Topic A Task 1
3 Task 2


I need the word doc to populate the headings automatically or if I can
generate a doc from Excel by using a macro by selecting the headings (maybe
some checkmark or something) I need that would be great. The Excel file
contains potentially thousands of topics but not all will be included in all
manuals.

Any ideas?


All times are GMT +1. The time now is 09:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com