The code I posted works fine as is. Do note that I updated it after posting, as I'd initially omitted a couple of lines. If you check Sheet 2 after running the macro, you should see the transformed data there.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|