+ Reply to Thread
Results 1 to 4 of 4

macro to copy duplicate in column and paste in another sheet with its corresponding row

  1. 03-12-2014, 11:09 PM #1
    patua
    patua is offline
    Registered User
    Join Date
    03-12-2014
    Location
    Tonga
    MS-Off Ver
    Excel 2007
    Posts
    10

    macro to copy duplicate in column and paste in another sheet with its corresponding row

    Hi all,
    Plese help me out.. iam searching for a macro that will find duplicate value in row A2 (id) then copy its corresponding column to a new sheet.. please refer to my attachment, and see the result i want on sheet2 and sheet3

    thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-13-2014, 12:10 AM #2
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: macro to copy duplicate in column and paste in another sheet with its corresponding ro

    Try
    Please Login or Register  to view this content.
    Last edited by jindon; 03-13-2014 at 01:38 AM.
    Reply With QuoteRegister To Reply
  3. 03-13-2014, 12:53 AM #3
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: macro to copy duplicate in column and paste in another sheet with its corresponding ro

    Hi Jindon,
    maybe
    Please Login or Register  to view this content.
    Last edited by nilem; 03-13-2014 at 01:00 AM.
    Reply With QuoteRegister To Reply
  4. 03-19-2014, 09:05 PM #4
    patua
    patua is offline
    Registered User
    Join Date
    03-12-2014
    Location
    Tonga
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: macro to copy duplicate in column and paste in another sheet with its corresponding ro

    Thank You so much Jindon and Nilem for helping me out..... Problem has been solved.
    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. MACRO for searching column for a letter and Copy/Paste the row into new MASTER sheet
    By cwitty22 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-17-2013, 04:24 PM
  2. Macro to find numbers in column and copy/paste to other sheet
    By maxbeard in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2013, 11:28 AM
  3. Macro to Copy duplicate values from a column to a separate sheet
    By eemrun in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-13-2013, 05:03 PM
  4. [SOLVED] Macro to identify a unique value in a column to copy and paste value to another sheet
    By bonny24tycoon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-04-2012, 07:59 AM
  5. Search column a for duplicate data and copy entire row to duplicate sheet
    By crazyAMP in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2012, 08:21 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