Hi,
I am trying to sort some VBA that will allow me to delete duplicate rows that could be anywhere in the current sheet.
The sheet consists of 9 columns and so the value in duplicate rows must be the same in each column for it to be counted as a duplicate.
I want to delete all duplicates but keep 1 copy of the row the search was based on.
I guess the best place to start would be to sort the sheet so it is at least a bit more uniformed.
Any help would be greatly appreciated.
I am trying to sort some VBA that will allow me to delete duplicate rows that could be anywhere in the current sheet.
The sheet consists of 9 columns and so the value in duplicate rows must be the same in each column for it to be counted as a duplicate.
I want to delete all duplicates but keep 1 copy of the row the search was based on.
I guess the best place to start would be to sort the sheet so it is at least a bit more uniformed.
Any help would be greatly appreciated.