Results 1 to 4 of 4

Macro to copy paste columns to specific rows

Threaded View

  1. #1
    Registered User
    Join Date
    11-23-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Macro to copy paste columns to specific rows

    Hi,

    This is a bit of a strange one - but probably relatively simple, I'll be honest I'm an amateur when it comes to macros.

    Basically what I would like to do is copy and paste 3 columns to specific rows. See attached for a sample of dummy data.

    What I would like to do is copy and paste
    C1 to A2, D2 to A3, E1 to A4
    then
    C5 to A6, D5 to A7, E5 to A8
    then
    C9 to A10, D9 to A11, E9 to A12
    then
    C13 to A14, D13 to A15, E13 to A16
    etc
    etc
    etc
    I have a full sheet of data like this, so would like a macro which would convert it all for me.

    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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