This application was working fine and then I added about 10 more fields to it and the "clear" code at the bottom is no longer working. I tried to debug and fix on my own but was unsuccessful. Could one of you take a look and fix this for me?
The input file holds the data that needs to be reformatted. The macro can be run by entering ctl/r. The output as tested is in the second workbook.
I need to have the duplicate SSN, Last, and First name cleared which is the code at the end of the macro. Let me know if you have questions. :-)