Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Macro to copy data into Word

    I would like a macro to copy data from Excel into Word as follows:

    1) Col E from Row 7 Onwards into Word under heading "per half" in same order as in Col E
    2) Col G Row 7 Onwards into Word under heading "mark full" in same order as in Col G
    3) Col I Row 7 Onwards into Word under heading "exam admit" in same order as in Col I

    I have attached sample data

    Your assistance in this regard is most appreciated
    Attached Files Attached Files

  2. #2
    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
    To me it would make much more sense if you want to enter the data into excel but display in word, to created the entire table in excel exactly the way you want it to look in Word, then select the table in excel and copy and link it in word. Then when you update in excel it will be automatically updated in word, without a macro at all...

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Steve

    Thanks for your valuable input. It makes 100% sense to do it the way you suggested

    Howard

Posting Permissions

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