Results 1 to 14 of 14

compare data and move it to new sheet

Threaded View

  1. #1
    Registered User
    Join Date
    09-03-2005
    Posts
    57

    compare data and move it to new sheet

    Hi, I'm new to VBA. and can any one assist me to have vba cod that can do the following.


    \1


    1. I need to compare data by "Item No" in both Sheets " sheet1 and sheet2" and move any duplicated rows to a new sheet "Sheet3".
    2 . in sheet three I need it to sort the data by "Item No"

    I will be appreciate any assist.
    Regards
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Compare 2 sheets and move unmatched to sheet 3
    By JAYRUES in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2012, 07:07 AM
  2. Compare columns in worksheets and move to correct sheet.
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-29-2011, 12:25 PM
  3. Loop through cells compare values add and move to another sheet
    By begilhang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2010, 04:07 AM
  4. How to identify text (compare) in one sheet, then move it another
    By mag7417 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-14-2005, 10:54 AM

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