Stan, both worked perfectly. What exactly is the difference in the two? As long as they both capture any occupied fields in column E this is what I have been looking for. You've saved me a LOT of time in my job. Thank you!