Export excel cells to Word with and defining heading1,2 and fontbolt and normal

[reiniervandijk1993]

Hi there,

My excel VBA experience is not much however I want to try something but can't work it out on my own.

I have a product list that will be different every time.
The list will take with it different cells to fill in different columns as well.

So this is the thing, I want a macro that opens Word and does the following;
Column A; check if the text is font bold or Normal.

Font bold cell will be paste as Heading 1
Newline
Normal cell - will be paste as Heading 2
etc. etc. till the end of the list in column A

Then there is subject in x columns (subject from normal text to bold in the word file)
And then there is text in the cell crossing Name and Subject. (Cell text normal to normal in the Word file.

If the specific cell is empty then the Subject should not be transferred to Word.

See the pictures in this post for more information.
Excel[IMG alt="Click image for larger version.
Name: Excelfile example.jpg Views: 1 Size: 17.4 KB ID: 26496"]http://www.vbaexpress.com/forum/attachment.php?attachmentid=26496&d=1588161167&thumb=1[/IMG] Word [IMG alt="Click image for larger version.
Name: worddoc example.jpg Views: 1 Size: 4.7 KB ID: 26495"]http://www.vbaexpress.com/forum/attachment.php?attachmentid=26495&d=1588161181&thumb=1[/IMG]

Second is actually when there is this >[cell] = ([1,1]) = ([r,c]) in a text cell.
Then print this in the Word document as the actual referredtext.
Example
excel file; text text text [1,1] text text
word file; text text text example text text

Helping me with this will help me very much. Thank you

 

[reiniervandijk1993]

Excel

Word