+ Reply to Thread
Results 1 to 2 of 2

Macro to copy and paste from excel to word, video explanation included

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Macro to copy and paste from excel to word, video explanation included

    http://www.youtube.com/watch?v=A1m7SWSquho

    Training Stats.xlsm
    Journal.doc

    Here is what I am trying to accomplish.

    In Excel
    Select U1:X1
    Shift control down arrow
    right click, copy

    In Word
    key shortcut to end of document
    Paste, use destination style

    In Excel
    right click, Copy Q1

    In Word
    Paste, merge formatting, this would take place right below the table that was previously pasted.

    In Excel
    Right click, Copy R1

    In Word
    Paste, merge formatting, this is done to the immediate right of the text "E1RM" which was previously pasted


    In Excel
    right click, Copy Q2

    In Word
    Paste, merge formatting, this would take place right below the previously pasted line

    In Excel
    Right click, Copy R2

    In Word
    Paste, merge formatting, this is done to the immediate right of the text "Total Volume" which was previously pasted

    In Excel,
    Right click, copy Q6

    In Word,
    Paste, merge formatting, this would take place right below the previously pasted line


    In Excel
    Right click, Copy R6

    In Word
    Paste, merge formatting, this is done to the immediate right of the text "Average Intensity" which was previously pasted

  2. #2
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Macro to copy and paste from excel to word, video explanation included

    Bump, anyone?

+ 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. Macro - Copy and Paste from Excel to Word
    By thegoodofall in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2011, 12:48 PM
  2. Excel macro - copy and paste to word
    By lsand in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-04-2010, 05:35 PM
  3. Macro excel to copy and paste table from Word
    By Shunlee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2008, 06:52 AM
  4. Macro to copy excel and paste in word
    By Daniel R. Young in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2005, 04:09 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