Hi there,

I have a worksheet which record the hours spent on each job for each employee. I have a macro which will import each employee time entry. When i import the data to the worksheet, i want to check if there is any duplicates data in case i import the same file twice. I have try to use conditional formatting before but i doesn't seem to be working. I have to check against 5 columns of data to check for the duplicates and conditional formatting seems like can only works for a single column.

Can someone please show me how to write a macro for this?

My data have total of 6 columns, start from column A to H, and the data entry starts from row 2. I have to check against column A,B,C,E&G for duplicates. I also want to highlight the duplicates instead of directly delete the row in case there is any mistake.

Thanks!!