Hi everyone.
What I have is a situation where data is inputted into columns A to G. Each line of data will include a telephone number in Column D.
If possible, I would like to have a macro that searches the column D and when it finds a duplicate telephone number, it will delete the entire rows that contain the duplicate telephone numbers so those lines are completely gone leaving only the one line where that telephone number first appears in column D along with leaving of course all lines where that tel number was never listed in the first place.
Can this be done?
What I have is a situation where data is inputted into columns A to G. Each line of data will include a telephone number in Column D.
If possible, I would like to have a macro that searches the column D and when it finds a duplicate telephone number, it will delete the entire rows that contain the duplicate telephone numbers so those lines are completely gone leaving only the one line where that telephone number first appears in column D along with leaving of course all lines where that tel number was never listed in the first place.
Can this be done?