+ Reply to Thread
Results 1 to 2 of 2

Move rows of data from several columns but not all columns

  1. #1
    Registered User
    Join Date
    12-18-2013
    Location
    california, usa
    MS-Off Ver
    Excel 2013
    Posts
    3

    Angry Move rows of data from several columns but not all columns

    Hi,
    What I want to do seems so basic but I can't figure it out.
    Column A is numbered 1 -100 successively
    Column B thru D contains data that goes with the assigned number in column A.
    I need to be able to move rows of data in column B through D to a different set of rows all at the same time (not one cell at a time) without disturbing the set numbers in column A. And with that, have all the other rows of data automatically adjust accordingly(not to be deleted or replaced).

    ZUKI

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Move rows of data from several columns but not all columns

    OK so how do we kn ow which rows to take? And it looks like you said you dont want to mess with the data in thwe 1st sheet? If thats the case, you dont want to move it, you need to reference it.

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. how to transpose/move data from columns to rows
    By snk2u in forum Excel General
    Replies: 7
    Last Post: 05-19-2013, 02:22 PM
  2. How do i move like data in columns to single rows?
    By ncsisz in forum Excel General
    Replies: 3
    Last Post: 07-23-2012, 12:09 PM
  3. Move data in rows to columns
    By hfler in forum Excel General
    Replies: 2
    Last Post: 07-14-2008, 12:32 PM
  4. [SOLVED] how do I move data in prexisting rows to columns?
    By darryl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-15-2006, 05:15 AM
  5. [SOLVED] Move Data from rows to columns...
    By Dan B in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2006, 12:50 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