+ Reply to Thread
Results 1 to 9 of 9

VB Code to compare text and cut Paste data

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to compare text and cut Paste data

    Hello:

    Please refer to attached file.
    I have 2 sets of data in Sheet1.
    I need VB Code to compare Column A text (Order#) data with Column U and if it finds same number then cut data from Column T : Y and paste
    it on the ralted row at column L.

    I have manually cut and paste 2 sets of data at column L as shown for Order # A2, A3 and compare in column U.

    Let me know if you have any questions.
    Thanks.
    Riz
    Attached Files Attached Files

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: VB Code to compare text and cut Paste data

    Maybe :
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  3. #3
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,527

    Re: VB Code to compare text and cut Paste data

    Here's my attempt:

    Please Login or Register  to view this content.
    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  4. #4
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to compare text and cut Paste data

    Hello karedog:

    Please refer to attached file.
    Thanks a lot....can you please add the code to highlight the data in column U which were copied in column M.

    Let me know if you have any questions.
    Thanks.
    Attached Files Attached Files

  5. #5
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: VB Code to compare text and cut Paste data

    Hi riz,
    You are welcome. See if this is what you want :
    Please Login or Register  to view this content.

  6. #6
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to compare text and cut Paste data

    Hello Karedog:

    Thanks a lot...it works for me.
    Riz

  7. #7
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to compare text and cut Paste data

    Hi Robert:

    Thanks a lot ...this will also work for me.
    Riz

  8. #8
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: VB Code to compare text and cut Paste data

    You are welcome Riz, thanks for marking the thread as solved and rep.points.

    Regards

  9. #9
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,527

    Re: VB Code to compare text and cut Paste data

    You are welcome Riz, thanks for marking the thread as solved and rep.points.
    That goes for me too

+ 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. VBA code to lookup cell in one sheet and compare to second then paste value
    By Zimmerman in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-05-2015, 01:11 PM
  2. VB Code to compare and paste data
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-21-2015, 11:49 AM
  3. Vba code to compare the 2 sheets and paste the values in 3rd sheet
    By Abinaya in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-02-2014, 01:47 AM
  4. [SOLVED] VBA code to open many files, copy text, close file, paste text in second work
    By Bikeman in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 02-11-2014, 12:59 PM
  5. Replies: 13
    Last Post: 11-29-2012, 08:25 PM
  6. Compare Data from 2 sheets and paste absent data on third sheet
    By junyi.ho in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-07-2010, 09:27 AM
  7. Compare Data from 2 sheets and paste absent data on third sheet
    By junyi.ho in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2010, 11: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