+ Reply to Thread
Results 1 to 7 of 7

Cut Mulitple Rows & paste single Column

  1. #1
    Registered User
    Join Date
    04-18-2011
    Location
    kuwait
    MS-Off Ver
    Excel 2003
    Posts
    5

    Smile Cut Mulitple Rows & paste single Column

    Hi,

    Is there any shortcut method to cut mutiple rows in to paste single column (But I am using cut single row and paste special - Transpose)


    AB AC AD AE AF
    BB BC BD BE BF
    ** CE CF CR CF

    AB
    AC
    AD
    AE
    AF
    BB
    BC
    BD
    BE
    BF
    **
    CE
    CF
    CR
    CF

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Cut Mulitple Rows & paste single Column

    What if it's blank instead of BE?

    is it in column also blank or skipped?
    BD
    BF

  3. #3
    Registered User
    Join Date
    04-18-2011
    Location
    kuwait
    MS-Off Ver
    Excel 2003
    Posts
    5

    Smile Re: Cut Mulitple Rows & paste single Column

    Blank or Skipped - it is doesn't matter.... I need it single column.

    Thanks for your effort...

  4. #4
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Cut Mulitple Rows & paste single Column

    tyr this code

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-18-2011
    Location
    kuwait
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Cut Mulitple Rows & paste single Column

    Please explain me step by step to execute the code

  6. #6
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Cut Mulitple Rows & paste single Column

    From your workbook press Alt+F11
    (now you will be in Visul Basic editor)
    from menu bar Insert>Module
    copy the code given in the last post and paste in the Module, then close the active window(VB editor)
    Press Alt+F8 (you will find list of Macros)
    select 'Start' macro then click Run

  7. #7
    Forum Contributor Charlie_Howell's Avatar
    Join Date
    09-27-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2007
    Posts
    218

    Re: Cut Mulitple Rows & paste single Column

    this is the Non-VBA technique that I use
    Attached Files Attached Files

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1