+ Reply to Thread
Results 1 to 3 of 3

Copy row from Sheet1 to Sheet2 when cell = Yes w/o duplicates

  1. #1
    Registered User
    Join Date
    12-02-2014
    Location
    WI
    MS-Off Ver
    MI OFficer Pro PLus 2010
    Posts
    1

    Copy row from Sheet1 to Sheet2 when cell = Yes w/o duplicates

    I have an excel spreadsheet that tracks what is still needed on files my company is processing.

    Column H = Follow up needed?

    If "YES" is in column H, that entire row needs to be copied and pasted into the next sheet (sheet2) without duplicates.

    Sheet1 headers on row 4, with data starting on row 5.
    Sheet2 headers on row 4, with date starting on row 5.

    Will need row data from A-H columns copy and pasted into sheet2 when H = YES

    The "without duplicates" is a luxury to be automated. I know that I can run the macro and then "remove duplicates" from sheet2 each time I open it. If I take this option, I will need to make sure that cell formatting is not affected when duplicates are removed.


    Thank you!

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Copy row from Sheet1 to Sheet2 when cell = Yes w/o duplicates

    What do you mean by duplicate?
    Is it the complete row to compare?
    Is it duplicate between sheet1 and sheet2 or is it inside sheet1?
    A short sample of your data will help to prepare the macro
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Copy row from Sheet1 to Sheet2 when cell = Yes w/o duplicates

    Please Login or Register  to view this content.

+ 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. [SOLVED] copy data from sheet1 to sheet2 based on column (A) sheet1 and column (C) sheet2
    By AWITCHER in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-13-2014, 03:20 PM
  2. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  3. [SOLVED] If cell value on Sheet1 not found on Sheet2 copy row to Sheet2
    By Yxx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2013, 04:15 AM
  4. Macro to copy range of cell from sheet1 to sheet2 based on a cell value in sheet2
    By drgwhizz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-25-2012, 10:39 AM
  5. IF Sheet1 Cell A2 = value, THEN copy Sheet1 Row 2 to Sheet2 Row 2....?
    By dan1980 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2009, 10:28 PM

Tags for this Thread

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