- I have a Word 2016 document consisting of sections and subsections, marked as 'Heading 1' and 'Heading 2', respectively. Each section has 1-3 short paragraphs.
- I want to copy the document into a 2-column table in Excel (2016). Column 'A' lists the section titles (all 'Heading 1' and 'Heading 2' fields), and the content from each of these sections will be copied into the adjacent cell in Column 'B'.
- The VBA code below works perfectly (from the Word document) to open a new Excel document and then create Column 'A', listing the section titles ('Heading 1' and 'Heading 2').
Can you please help me adapt this code so that after copying each section title/Heading into Column 'A', the content in that section is copied into the adjacent cell in Column 'B'?
Many thanks in advance for your time and guidance.
Please Login or Register to view this content.
Bookmarks