Vba macro code for removing cells and appearing it continously

Originally Posted by AB33

Dates are formatting issue and no error with the code.
You can simply highlight the entire column C and format it as data. I have tried to include a line on the output code, but does not make any difference. If I include the formatting on the source sheet, it seems to work. See attached amended code.

Dear AB33,
Thanks for the apt answer... thank you so much for spending your valuable time... the code is working.. its GREAT...
But a small request .. can you attach me the code separately???? because I could not find the code in module.

Thanks & Regards,
Dharani.