Thanks! That's exactly what I did- recorded a new macro attached to a button so I can copy and paste the data in and transform it with one click. I appreciate all the time you've taken to help me!