Disregard my last reply. It worked beautifully, Tom. It just didn't do it with data that was already entered in the spreadsheet but as soon as I added something to another row, it worked!

Thanks so much!