Hello, I'm trying to build a macro that can automatically look at a state abbreviated ID (TX, KS, NY, etc.) in a single column and return the full state name (Texas, Kansas, New York, etc.) in a blank column to the right. I need to be able to use this macro in any workbook, as I will refer to...