none
Help: Excel Range Output to Word Tables RRS feed

  • Question

  • I am looking for a way to take a range of cells in an XLS worksheet and output them into word tables.  The resulting word tables are always 2 cols with as many rows in the XLS worksheet.  The total number of word tables is essentially column count of XLS range minus 1.

    So, if my range was, say a worksheet with these values:

    a, A, B, C

    b, D, E, F

    c, G, H, I

    I want to create 3 (2x3) tables in word with the first col for all tables containing the first col data (i.e., a,b,c) and the 2nd column for each of the tables will cycle through the cols in the range.  So, the resulting tables in word will look like

    a, A

    b, D

    c, G

    <page break>

    a, B

    b, E

    c, H

    <page break>

    a, C

    b, F

    c, I

    <page break>

    Appreciate any help!  TIA

    Wednesday, September 5, 2018 1:31 PM

All replies

  • I could use the Print Titles from the Page Layout menu from within Excel and output to a PDF but I need it in Word as tables on a separate page so that is what I am struggling with...  
    Wednesday, September 5, 2018 2:54 PM