Results 1 to 4 of 4

Thread: Macro Copy Columns and Paste in rows.

  1. 02-28-2013, 10:16 PM #1
    TommyKris
    TommyKris is offline
    Junior Member
    Join Date
    Nov 2012
    Posts
    3
    Rep Power
    0

    Macro Copy Columns and Paste in rows.

    Hi,

    I'm currenlty try to create a macro that takes all data in a set number of columns and paste it below each other. I want it to loop this until last populated column.
    The number of rows in the sheet can change but is around 300- 400.

    Current
    ABC111222333444555
    ABC111222333444555


    End Result
    ABC111
    ABC111
    ABC222
    ABC222
    ABC333
    ABC333
    ABC444
    ABC444
    ABC555
    ABC555


    Any help would be highly appricated.

    Thanks
    Last edited by TommyKris; 02-28-2013 at 10:19 PM.
    Reply With Quote Reply With Quote
  2. 02-28-2013, 10:30 PM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi TommyKris,

    welcome to ExcelFox!!

    Could you attach a workbook ?
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  3. 03-01-2013, 01:46 PM #3
    TommyKris
    TommyKris is offline
    Junior Member
    Join Date
    Nov 2012
    Posts
    3
    Rep Power
    0
    Attached workbook.

    What i'm trying to achive is that starting from column AC i want every 14 columns to to be copies and pasted in at first empty row in range O:AB. Macro shoud run all columns until first empty column.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  4. 03-06-2013, 02:36 PM #4
    TommyKris
    TommyKris is offline
    Junior Member
    Join Date
    Nov 2012
    Posts
    3
    Rep Power
    0
    Anyone??


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwhVTFaD469mW9wO194AaABAg. 9gJzxwFcnPU9gORqKw5tW_
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugyb8nmKKoXvcdM58gV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwvvXcl1oa79xS7BAV4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgxvIFArksPprylHXYZ4AaABAg
    https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 07-11-2023 at 01:06 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Copy/Paste Excel Range/Chart into Powerpoint VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 03-13-2014, 02:59 PM
  2. Macro to copy data in specific Columns
    By Howardc in forum Excel Help
    Replies: 0
    Last Post: 04-19-2013, 10:42 AM
  3. VBA -- Copy/Paste across sheets
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 09-21-2012, 02:07 PM
  4. Copy webpage and paste it as HTML into an excel sheet using vba
    By LalitPandey87 in forum Excel Help
    Replies: 2
    Last Post: 04-08-2012, 09:42 AM
  5. Trapping Copy To Range Before Copy/Cut Paste
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-07-2011, 07:48 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
  •  

Forum Rules