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

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


    I need to paste new data 3 times @ least a day for each shift. ( imprtant thing is to see data SIDE BY SIDE)

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


    Change to

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


    It worked once then on repeat same thing happen. I start a new workbook and try again tomorrow. enough for me today. thanks Jindon

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


    Jindon- Looks like when I paste new data "space in between and in front of last name and first name creating issues. Would you wite a few lines of code to trim the space and commas make as one string please in s sepatate sub - Example Smith, John should be SmithJohn- All the names are in column A on bothe sheets.

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


    You know the problem?


    You should upload the data with all the possible combination/pattern of Col.A to be matched.


    I will only write a code from what you upload, not by guess.

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


    jindon
    a(i, UBound(a, 3)) = dic(txt)(2) trying to modify your code to copy from column 3 values of Dept Hours to match entries of Time Clock - but no luck

Participate now!

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