+ Reply to Thread
Results 1 to 5 of 5

VBA to find data in one column and move it to another column

  1. 08-12-2013, 10:34 AM #1
    toneill is offline
    Registered User
    Join Date
    08-12-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2010
    Posts
    5

    VBA to find data in one column and move it to another column

    I have data in column A that is imported from a text file. I want to copy "Like" data to different columns. For example:

    Column A Column B Column C
    Test1 Test1 Bent1
    Bent1 Test2 Bent2
    Bent2 Test3 Bent3
    Test2
    Test3
    Bent3

    Can anyone help me with the VBA code to find data that is like each other, then loop through and putting it into another column?
    Last edited by toneill; 08-13-2013 at 08:46 AM.
    Reply With QuoteRegister To Reply
  2. 08-12-2013, 10:39 AM #2
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA to find data in one column and move it to another column

    Instead of duplicating posts, you would be better off if you could attach a sample.

    http://www.excelforum.com/excel-prog...50#post3361450
    Reply With QuoteRegister To Reply
  3. 08-12-2013, 01:06 PM #3
    toneill is offline
    Registered User
    Join Date
    08-12-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: VBA to find data in one column and move it to another column

    Sorry about that, here is a spreadsheet that shows the before and after table that I need a VBA script to help me.

    Thanks,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 08-12-2013, 02:04 PM #4
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA to find data in one column and move it to another column

    Try the attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 08-13-2013, 08:44 AM #5
    toneill is offline
    Registered User
    Join Date
    08-12-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: VBA to find data in one column and move it to another column

    This is Great! Works wonderful.

    Thanks for the assistance
    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)

Similar Threads

  1. Move Multiple-Column Data to One Column (not Transpose)
    By CriticalEric in forum Excel General
    Replies: 5
    Last Post: 04-22-2012, 07:17 PM
  2. Find a number in Column A matching Column B & move # in C matching Column B
    By JudeH in forum Excel General
    Replies: 1
    Last Post: 07-25-2011, 01:07 PM
  3. Move Column Data to Last Empty Column On Sheet
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2010, 03:16 PM
  4. find name; search column; if date found-return 3 data pts; move to next row
    By cdl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2008, 10:43 AM
  5. find and move data within a column
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2006, 02:20 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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1