Hello, looking to do 2 things with duplicate values in VBA:
1.) Need to highlight duplicates in Sheet1, column E and when comparing it to Sheet2, column E. It needs to be the whole column as data is being added and removed daily. Only sheet1 needs to be highlighted. I tried to do a countif conditional formatting, but it was not working.
2.) Need to delete the full row, for duplicates in Sheet1, column E, when compared to Sheet3, column E.
Thanks
1.) Need to highlight duplicates in Sheet1, column E and when comparing it to Sheet2, column E. It needs to be the whole column as data is being added and removed daily. Only sheet1 needs to be highlighted. I tried to do a countif conditional formatting, but it was not working.
2.) Need to delete the full row, for duplicates in Sheet1, column E, when compared to Sheet3, column E.
Thanks