Because of the nature of the workbook I am on, I don't have the liberty to post it as an example. I apologize. If there is no way to highlight all the cells at once, that's okay. I can move on to another project and keep doing this manually every day.
I can't really delete the data either.