Hi,

By the first part do you mean the conversion from the Original sheet to the 'After Macro Flash' sheet? I though that's what your Flash macro was doing, or are you just wanting to do it in a more efficient way?

If so what's the source of the data? Is it a separate csv/txt file which you currently manually open, copy and paste?