+ Reply to Thread
Results 1 to 5 of 5

Cut and paste to another column

  1. #1
    Registered User
    Join Date
    01-04-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    33

    Cut and paste to another column

    I have the data 1 To 100 from A1 to A100.... i trying to do that if the row count more than 25, the entire row data will move to column B..anyone can help?
    Isaac Koh

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Cut and paste to another column

    You question is not clear to me.

    Maybe you can add an column befor column A.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    01-04-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: Cut and paste to another column

    Erm...example like data from A1 to A100 is 1 to 100... i would like to make if the row count more than 25, will move to column B..which mean 26-100 will move to column B... understand?

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Cut and paste to another column

    Does this help?

    Please Login or Register  to view this content.

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

    Re: Cut and paste to another column

    I suspect that you may be looking for something more than this, but since you asked, try this.

    Please Login or Register  to view this content.
    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

+ 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. Copy and Paste data in column A number of times displayed in column B
    By anthony232 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2013, 05:13 PM
  2. Replies: 3
    Last Post: 05-22-2013, 01:08 AM
  3. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 PM
  4. -- Selective Cut and Paste -- Cut and Paste based off of B Column's Content --
    By brad70989 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-09-2011, 03:29 PM
  5. Replies: 4
    Last Post: 08-31-2010, 10: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1