+ Reply to Thread
Results 1 to 10 of 10

Cut info from a column and paste it under a designated column

  1. 01-02-2013, 06:30 AM #1
    VKS
    VKS is offline
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Cut info from a column and paste it under a designated column

    Dear Experts
    I am seeking help on a macro which will cut info from a column and paste it under a designated column.
    There is a huge table starting from row 2 goes up column CH row 2 is a header (Row 1 is blank). Data is till row 110 (Row numbers and column numbers may vary from file to file). Column A to C have text and data starts from column D and all the way to CH. Help is required to cut all the columns starting from E and paste it column D and do it till the last column.
    To identify data it should also insert a column A and paste the header of each row which is cut and pasted in column D
    Not too sure if I have explained myself correctly or not hence attaching a sample.
    Thanks in advance/VKS
    Attached Files Attached Files
    Last edited by VKS; 01-03-2013 at 12:54 PM.
    Reply With QuoteRegister To Reply
  2. 01-02-2013, 11:24 AM #2
    rcm
    rcm is offline
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Cut info from a column and paste it under a designated column

    try this

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 01-02-2013, 12:36 PM #3
    VKS
    VKS is offline
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Cut info from a column and paste it under a designated column

    I get the compile error. "Expected End Sub"
    Reply With QuoteRegister To Reply
  4. 01-02-2013, 12:56 PM #4
    rcm
    rcm is offline
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Cut info from a column and paste it under a designated column

    just add end sub at the bottom, that line did not get copied...
    Reply With QuoteRegister To Reply
  5. 01-02-2013, 01:10 PM #5
    VKS
    VKS is offline
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Cut info from a column and paste it under a designated column

    Attached, please find the error i am getting now.
    Reply With QuoteRegister To Reply
  6. 01-03-2013, 01:12 AM #6
    VKS
    VKS is offline
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Cut info from a column and paste it under a designated column

    Sorry. Attachment didnt get loaded. Attached is the screen shot of new error i am getting now.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 01-03-2013, 10:46 AM #7
    rcm
    rcm is offline
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Cut info from a column and paste it under a designated column

    make sure that your tabs are named sheet1(input), sheet3(output)
    Reply With QuoteRegister To Reply
  8. 01-03-2013, 11:58 AM #8
    VKS
    VKS is offline
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Cut info from a column and paste it under a designated column

    Says Runtime error 9
    subscript out of range
    Reply With QuoteRegister To Reply
  9. 01-03-2013, 12:18 PM #9
    rcm
    rcm is offline
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Cut info from a column and paste it under a designated column

    I am including the entire file. It ran in my computer
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 01-03-2013, 12:36 PM #10
    VKS
    VKS is offline
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Cut info from a column and paste it under a designated column

    Thanks a lot. Worked like a magic.
    Reply With QuoteRegister To Reply
  11. 01-03-2013, 12:46 PM #11
    VKS
    VKS is offline
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Cut info from a column and paste it under a designated column

    Dear RCM, I think i must share with you the reason i was getting the errors that i was getting. My real time workbook had only one sheet.
    After inserting two more sheets and giving them name Sheet1(to real data sheet) sheet2 (a blank sheet) and sheet3(again a blank sheet) and running the macro from sheet1 gave me what both of us expected as outcome. I am impressed. Thanks a lot once again. VKS
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1