Splitting dates and inserting rows quickly

Hello, i have a table of about 7 columns which I regularly run a macro to break down.
the problem i have is it takes so long, i wrote this but was wondering if anybody could suggest a quicker way of performing this kind of task?

Original table layout (actual table has anywhere between 100-200 rows):
Capture.JPG

Finished table layout:
Capture1.JPG

Please Login or Register  to view this content.

Appreciate if anybody can help out with any advice on how i could shorten the time it takes to finish this task?

ahh thanks for your reply, sorry but i didnt post the full code, and i have already included at the start of the macro.