Delete Duplicate Rows depend on creteria on Col A and Col B

  • I got 2 sheets one with Employees name in col A number of hours worked in col B. Second sheet is download form time clock which has Name in Col A and Hours worked in Col B and other details in other columns. I want MACRO to delete matching rows depend on Col A and Col B . any guidance please

  • Re: Delete Duplicate Rows depend on creteria on Col A and Col B


    Seems I missed this earlier...



    Assumptions:


    All data is contiguous with no blank rows
    The Time Clock sheet always starts Row 1, Col 1

  • Re: Delete Duplicate Rows depend on creteria on Col A and Col B


    It was trying to lookup a value which does not exist - added a FIND to ensure the value being looked up does exist...


    Of course, could have handled this any number of ways...

  • Re: Delete Duplicate Rows depend on creteria on Col A and Col B


    Hi..


    New object for me.. but i think this does it..


  • Re: Delete Duplicate Rows depend on creteria on Col A and Col B


    Both works- cytop code without header and apo code leave the headings where it is- thanks both of you. How do I high light difference on Time Clock in one go (same code module) putting in a separate sheet side by side P-l-e-a-s-e

  • Re: Delete Duplicate Rows depend on creteria on Col A and Col B


    Can you elaborate on both these statements..


    Quote

    How do I high light difference on Time Clock in one go (same code module)


    I don't get that.. I mean.. you are deleting the rows on the "Dept Hours" sheet if they DO exist on the Time Clock sheet... so .. how are you going to highlight the differences on the Time Clock sheet (rows that DO NOT exist on the Dept Hours sheet and Time Clock sheet).. if they don't exist to be highlighted?


    and


    Quote

    putting in a separate sheet side by side


    The more detail the better..

  • Re: Delete Duplicate Rows depend on creteria on Col A and Col B


    I scrambled on explanation. 1. correct delete similar entries. 2. Now I have 2 difference between 2 sheets. "Time clock has ALL entries but Dept Hours has <> entries (after macro). I want to see difference between Dept hours to Time Clock. Time Clock had actual hours and Dept Hours is what they are claiming. eg if one person is late Time Clock say only work for 7.75 hours, But Dept Hours say 8 hours I need to see this person side by side so I can go and fix the time correctly. I don't want to see if both entries are same , I want to deal with not equal entries. Thanks

  • Re: Delete Duplicate Rows depend on creteria on Col A and Col B


    Hi..


    Try this..
    I added a new sheet called "Variances"..


    Your desired results should display there..


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!