Wow this is perfect! I just got it to work properly. (Again, I apologize for my lack of knowledge) Is there anyway to use this function in a macro though? Because I need to do this for multiple sheets, and it would be easier if I could simply macro it instead of having to copy and paste into every sheet.
I have to also really thank you for this because this does exactly what I was looking for. I noticed that you saw my "cross-posting". I couldn't figure out how to use this function, and was too embarrassed to ask, so I thought I'd go somewhere else /: Either way, I figured it out and it works like a charm!