Results 1 to 14 of 14
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Location
    Bethlehem, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Can you create a macro to run in Excel against a Word table to pick up data in a mutiple word columns / rows that need to be added to Excel rows? 1:1.

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    The short answer is YES.
    Is it whole table to Excel, or specific bits of the table to excel?
    Andrew

  3. #3
    Star Lounger
    Join Date
    Jun 2001
    Location
    Bethlehem, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the quick response. I am asking this question for a friend. I believe she need parts of the table and not the whole table.

  4. #4
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    It is the moving through the Word Table and selecting the right data which is the marginally harder
    part of the exercise.
    If it was the whole lot, you could write a Macro to copy and paste.
    Andrew

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Perhaps the code from the sample files in the thread starting at
    http://lounge.windowssecrets.com/ind...dpost&p=561052
    can be adapted.

    This was a word doc that had several tables and needed to extract certain information from each table and rearrange the data into a combinced data table format in Excel.

    Steve

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Perhaps the code from the sample files in the thread starting at
    http://lounge.windowssecrets.com/ind...dpost&p=561052
    can be adapted.

    This was a word doc that had several tables and needed to extract certain information from each table and rearrange the data into a combinced data table format in Excel.

    Steve

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Perhaps the code from the sample files in the thread starting at
    http://lounge.windowssecrets.com/ind...dpost&p=561052
    can be adapted.

    This was a word doc that had several tables and needed to extract certain information from each table and rearrange the data into a combinced data table format in Excel.

    Steve

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Perhaps the code from the sample files in the thread starting at
    http://lounge.windowssecrets.com/ind...dpost&p=561052
    can be adapted.

    This was a word doc that had several tables and needed to extract certain information from each table and rearrange the data into a combinced data table format in Excel.

    Steve

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Perhaps the code from the sample files in the thread starting at
    http://lounge.windowssecrets.com/ind...dpost&p=561052
    can be adapted.

    This was a word doc that had several tables and needed to extract certain information from each table and rearrange the data into a combinced data table format in Excel.

    Steve

  10. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Perhaps the code from the sample files in the thread starting at
    http://lounge.windowssecrets.com/ind...dpost&p=561052
    can be adapted.

    This was a word doc that had several tables and needed to extract certain information from each table and rearrange the data into a combinced data table format in Excel.

    Steve

  11. #11
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Perhaps the code from the sample files in the thread starting at
    http://lounge.windowssecrets.com/ind...dpost&p=561052
    can be adapted.

    This was a word doc that had several tables and needed to extract certain information from each table and rearrange the data into a combinced data table format in Excel.

    Steve

  12. #12
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Perhaps the code from the sample files in the thread starting at
    http://lounge.windowssecrets.com/ind...dpost&p=561052
    can be adapted.

    This was a word doc that had several tables and needed to extract certain information from each table and rearrange the data into a combinced data table format in Excel.

    Steve

  13. #13
    Star Lounger
    Join Date
    Jun 2001
    Location
    Bethlehem, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I need this macro to go row by row and copy the data from Word and paste it in Excel.

  14. #14
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    The example files I pointed to, so exactly that. It selects out of several word tables and extracts rows and columns and even loops through the tables. The most we can offer is example code that you can hopefully adapt unless you provide details and a sample word file to pull from and how you want it put into excel.

    Steve

Posting Permissions

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