+ Reply to Thread
Results 1 to 4 of 4

VBA loop for copy rows and paste special for columns

  1. #1
    Registered User
    Join Date
    05-24-2020
    Location
    poland
    MS-Off Ver
    365
    Posts
    2

    VBA loop for copy rows and paste special for columns

    Hi,

    i would like to write code that will copy rows and paste them for one column (in one list).
    For example: i'd like to copy range A1:C3 and paste it for one column.

    Could you help me?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: VBA loop for copy rows and paste special for columns

    A quick two steps in Power Query. No code required. Highlight your range and Unpivot Rows. Delete the first column. See the attached. Here is the Mcode generated by these steps.

    Please Login or Register  to view this content.
    Review PQ
    In the attached file
    Click on any cell in the new table
    On the Data Tab, click on Queries & Connections
    In the right window, double click to open Query
    Review PQ steps
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    05-24-2020
    Location
    poland
    MS-Off Ver
    365
    Posts
    2

    Re: VBA loop for copy rows and paste special for columns

    Thanks it's work very well.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: VBA loop for copy rows and paste special for columns

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. [SOLVED] Copy data and paste special from specific rows to next empty row
    By hkbhansali in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2019, 09:55 AM
  2. [SOLVED] Macro with text to columns, insert rows, and paste special>transpose
    By Schern in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-21-2016, 11:43 AM
  3. Copy and Special Paste Loop
    By TexasBobcat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2015, 01:14 PM
  4. [SOLVED] Macro with text to columns, insert rows, and paste special>transpose
    By diaphanous1138 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-22-2013, 02:49 PM
  5. Copy/paste special to another worksheet and in descending rows
    By TheRobsterUK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2012, 03:57 AM
  6. [SOLVED] Code for Copy and Paste Special- Values in Columns
    By gautamacharya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2012, 04:51 PM
  7. Replies: 6
    Last Post: 12-09-2011, 05:22 AM

Tags for this Thread

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