VBA to keep format when concatenating

[isasa74]

HI snb
Belgium? I think I once bumped into you web site

@ SamT
Thanks!

I will try to find you a more valuable Gulden for you for sure I'll try hard
and the letter obviously to say thank you

No. It's not the main target, it's not even a minor target.

To use a football analogy, concatenating the NumberFormats is merely one way to shape your tongue while head butting the ball down field, and I am not even sure that a head butt is the best possible passing technique in your case.

I don't know if you are familiar with this old adage, but you've been focused on one tree for so long that you have forgotten the forest.

Great SamT...I had been studying literature for all my life...then when I was going to starve... I adapted my dreamer mind to technical jobs as much I could.. I
was not familiar with your old adage but now I love it

When I say that my main target was that silly thing with the concatenation, I meant that I disturbed you guys for that reason... as in my very bugged opinion the tool was ok and the only missing thing was the possibility to have also the format (EUR/USD) reported in sheet1...

Now your immensely more technical mind unveiled as the all procedure is very subject to errors, the Logic Bomb as you call it.
And now that I read your explanation, that unfortunately I can only understand partially, I see that my tool was very rudimental...

What Can I say? I can only say thanks and asking you to be patient please , as you certainly have been till now.
Your algorithm sounds supremely good, and if it's not asking too much of your time yes please let's do it

I attached the latest version of the file, where you have both mine and yours codes, only one comment about your codes:

We can rearrange the code in Sheet2NumFormats to standardize them before you transfer the data into your system. The you can run both Sheet2 subs to clean it up before transfer.
Remove these constants and Replace the three Format Column Code sections With this

I did it I removed the three constants and added the long section you posted but I got an error so I went back to the first version you sent... , see the screenshot please.

Thanks