Flatline, If got time to work on this, if it would help. I would start a new sheet, copy all names from each sheet and then delete dups from each state. Once done, we would delete the other sheets. We both could keep a backup offline for recovery. What do you think?
Bookmarks