I have attached an extract of a worksheet where I import a csv file find the duplicate bits of information based on 5 cell values form sheet Temp5 and return True or False in column AI of sheet1. The position of the data is where it is found on its respective sheets.
The assistance I am looking for is to delete the duplicates (red blocks of data) on sheet Temp5 and move the cells left. The data will always start from row 4 and the maximum would be 100
Any assistance would be greatly appreciated. Thank you
Bookmarks