Results 1 to 3 of 3

Automate repititive copy and paste

Threaded View

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    18

    Automate repititive copy and paste

    Hi,

    I have the following task which I tried to record as a macro but could not get it to paste at the required location.

    I have data in columns K to Z, each with data from rows 1 to 120

    I would like a macro to copy data from column K, rows 1 to 120 and paste the data to column E, rows 1 to 120
    Next, copy data from column L, rows 1 to 120 and paste to column E, rows 121 to 241
    Next, copy data from column M, rows 1 to 120 and paste to column E, rows 242 to 362
    and so on until the final column Z, rows 1 to 120 and paste to column E, rows .....

    I tried a few recording of the steps but I am unable to get it to work.

    Sub Cut_Paste()
    '
    ' Cut_Paste Macro
    '
    
    '
        Range("K1:K120").Select
        Selection.Copy
        ActiveWindow.SmallScroll Down:=-81
        Range("E1").Select
        ActiveSheet.Paste
        Range("L1:L120").Select
        Application.CutCopyMode = False
        Selection.Copy
        Range("E121").Select
        ActiveSheet.Paste
        ActiveWindow.SmallScroll Down:=24
    End Sub
    Thank you

    Raury
    Last edited by alansidman; 10-29-2014 at 07:51 AM. Reason: code tags added.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to automate copy paste
    By alyasch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2013, 09:36 AM
  2. Automate copy and paste and copy and paste back to excel
    By Bmw318be in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2013, 05:42 AM
  3. Automate copy and paste and copy and paste back to excel
    By Bmw318be in forum Access Tables & Databases
    Replies: 0
    Last Post: 02-23-2013, 05:42 AM
  4. Replies: 4
    Last Post: 06-02-2009, 06:25 AM
  5. Automate Cut/Copy/Paste from Excel Cells
    By Do it the Easy Way in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2006, 12:20 AM

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