Macro to change 1) part of string, 2) the order of characters inside a string, 3) format

[Karl Gustaf Karsten]

Hi all!
I have little experience with VBA but have successfully search this forum before and found solutions to my problems. However, this time I cannot find the solutions I need, so I will be very grateful if anyone can help me!

My overall goal is writing a macro that merges two databases that carry different information for the same companies. I have sketched out a few steps I need to complete – I’m currently stuck on step one (changing the dates).

I’ve attached a short example of how the data is organized in the two databases, as well as how I want the result to be after I run the code.
There are 200 000+ rows, and more rows are generated all the time – Code must include unspecified number of rows.

Macro I want:
1)
In sheet Data1 (column G) – Change string and format:
Because of the language I’m running I need to change “May”, “Oct”, and “Dec” to “Mai”, “Okt”, and “Des” and have the format changed to date.
The macro I’m using changes the words but not the format.

2)
In sheet Data2 (column B) – Change string and format:
Change the string from YYYYMMDD to DD.MM.YYYY and format as date.
I have no clue on how to manipulate the string like this.
The result must be in the way that others can paste data from the two databases (Data1 and Data2) into the respective worksheets and then run the macro.

The macro I'm using:

Please Login or Register  to view this content.

Any help is greatly appreciated!

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[Karl Gustaf Karsten]

Thank you, AlphaFrog!
I think this does it. Unfortunately, I don't have access to the full file during the weekend. So unless I've overlooked something I'll mark this as thread as solved after I've tested it on Monday

I really appreciate your help! You are awesome

[AlphaFrog]

You're welcome. Thanks for the feedback.