+ Reply to Thread
Results 1 to 4 of 4

Moving data from single excel column to word table with several columns

  1. #1
    Registered User
    Join Date
    05-17-2014
    MS-Off Ver
    Excel 2003
    Posts
    5

    Moving data from single excel column to word table with several columns

    So I have a little bit of a problem getting something to work for me. I have data from a single excel column that I am trying to display in a word document table. I have attached the 2 pictures for reference. While I have been able to get it done manually with cut and paste, I was trying to get it to automate a little more. The new number of item numbers should hopefully update, but I cannot get the formula in word to work correctly. Nor am I able to get the auto formatting to go through. Does anyone have any thoughts?
    Attached Images Attached Images

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,593

    Re: Moving data from single excel column to word table with several columns

    Simply use a single-column table and format the portion of the document containing it as a 3-column Section.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    05-17-2014
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Moving data from single excel column to word table with several columns

    How could I get it to ignore blanks though, and the number if items changes regularly as well. it gets slow when there are 700 items to list.

  4. #4
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,593

    Re: Moving data from single excel column to word table with several columns

    Your first post said nothing about blanks. Even with 700 rows, though, it's a simple copy/paste. You could then use a Word macro to delete the empty rows. See, for example: http://www.msofficeforums.com/word-v...tml#post118466
    Last edited by macropod; 05-10-2018 at 10:08 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extracting Data from Word Table to Excel 2013 into specific columns
    By achieve1 in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2017, 12:41 AM
  2. Macro to Import Column/Rows from Word Table to Excel Columns
    By atom2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-08-2014, 01:57 AM
  3. Replies: 2
    Last Post: 03-07-2013, 02:16 PM
  4. Moving data from single to multiple columns and merging
    By flagship in forum Excel General
    Replies: 15
    Last Post: 12-31-2012, 10:06 AM
  5. Replies: 5
    Last Post: 02-07-2012, 04:55 PM
  6. Moving data from a single cell to column
    By virtualized in forum Excel General
    Replies: 6
    Last Post: 04-26-2011, 02:11 PM
  7. moving column data to single row - anyone else?
    By fun4four in forum Excel General
    Replies: 4
    Last Post: 07-30-2010, 03:59 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1