+ Reply to Thread
Results 1 to 2 of 2

Copying data from Excel to pre-existing Word table

  1. #1
    Registered User
    Join Date
    01-03-2020
    Location
    US
    MS-Off Ver
    2019
    Posts
    85

    Exclamation Copying data from Excel to pre-existing Word table

    Hi friends,
    I have provided a sample excel and word file for better understanding the task I want to do. I have an Excel file which contains some information about PM services. In the provided Word file, you see that there is a page with a table (Pre-Existing).
    I want to copy each cell in the Excel file to the corresponding cell in the Word table. My Excel file may contain around 1300 rows, so I need to add the same Word page with the same text and table style as I need to fill all those 1300 rows in Word file (the sample file has 99 data rows).
    Please guide me to write a VBA code for automating this task.
    Attached Files Attached Files
    Last edited by fa2020; 07-24-2020 at 09:13 AM.

  2. #2
    Registered User
    Join Date
    01-03-2020
    Location
    US
    MS-Off Ver
    2019
    Posts
    85

    Re: Copying data from Excel to pre-existing Word table

    Is there any solution?

+ 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. Copying Excel table range to an existing PPT slide, pasting as TABLE, not as PICTURE
    By gurnblanston27 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2016, 04:44 PM
  2. Replies: 0
    Last Post: 05-16-2014, 11:07 AM
  3. Pasting data into an existing Word Document Table
    By steeladept in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 04:58 PM
  4. [SOLVED] Copying Excel Range into existing MS Word Table
    By ericv101 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-27-2013, 06:25 PM
  5. Copying from Excel to a table in Word
    By woolleyy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2013, 12:39 PM
  6. Need Help in copying a Table from Word file to Excel
    By sure2005 in forum Excel General
    Replies: 1
    Last Post: 10-19-2010, 03:23 PM
  7. Copying word table formats to excel using VBA
    By mmussmann in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2009, 04:26 PM

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