Vba macro code for removing cells and appearing it continously

Originally Posted by patel45

I'm sorry, but my code works on your attached file, it makes a copy of sheet1 then changes it, explain better please

Dear Patel,
I m sorry actually it is giving the same input only in the next sheet for me and it is showing error as some 400. sir I m attaching you the excel file with your code and output for your kind reference and perusal. patel sir.xls

Awaiting for a positive reply..
Thanks & Regards,
Dharani.

Originally Posted by patel45

Please, remove all images and comments and try my code again

Dear Patel,
I am really sorry to tell this.. for me its not working, maybe I m not clear to you.. That's ok Sir, leave it.I must not take your time much... maybe not this time, for my next question, I hope your contribution will be more useful and helpful.

My heartfelt thanks to you..

Regards,
Dharani.