Vba macro code for removing cells and appearing it continously

Dear Sir /Madam,
The sheet 1 (input file) is the given file. i need output like in the Sheet2(required output sheet). For easy understanding i had given colors for your kind reference. from that lease remove the cell apsim version cell and the headings from the second set onwards.

in simple words I need output like in the second sheet. (hope I m not confusing)please do help me...

please oblige and do the needful... PLEASE FIND THE ATTACHMENT...

Thanks & Regards,
Dharani.
full files.xls

Originally Posted by venkat1926

see attched file "Dharani ,,,,,". first and second sheets are yours. I have added a sheet called "result"
if there is problem in donwloading the file revert to the newsgsroup

Please Login or Register  to view this content.

Dear Venkat,
Thank you for the amazing code... its working... My heartfelt thanks to you for you honest and quick effort you made... a small clarification is required.. this code is working only in your attached excel sheet. if I copy and paste the code in full files excel sheet, which I attached above with my question, it is not working... please reply...

Awaiting for a positive reply..

Thanks & Regards,
Dharani.

Originally Posted by patel45

Please Login or Register  to view this content.

Dear Patel,
My heartfelt Thanks for you for the honest and quick effort you made for my help... but Sir the code is not seems to be correct which means it is not giving the required output which I want... it is giving back the sheet 1 data only... I need output like which is in sheet 2.

Please reply Sir....

Awaiting for the positive response....

Thanks & Regards,
Dharani.

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.

The attach code works on your attached sample.

Originally Posted by AB33

The attach code works on your attached sample.

Dear AB33,
Thank you for the honest and quick effort you made.... but see at the column DATES (c column) there are some mistakes. dates are wrongly appearing. if you rectify and give this, it would be highly helpful for me.

Awaiting for a positive response...

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.

Originally Posted by Dharani Suresh

Dear Venkat,
Thank you for the amazing code... its working... My heartfelt thanks to you for you honest and quick effort you made... a small clarification is required.. this code is working only in your attached excel sheet. if I copy and paste the code in full files excel sheet, which I attached above with my question, it is not working... please reply...

Awaiting for a positive reply..

Thanks & Regards,
Dharani.

Dear Venkat,
Thank you for the amazing code... its working... My heartfelt thanks to you for you honest and quick effort you made... a small clarification is required.. this code is working only in your attached excel sheet. if I copy and paste the code in full files excel sheet, which I attached above with my question, it is not working... please reply...

Awaiting for a positive reply..

Thanks & Regards,
Dharani.

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.

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.

Dharani,
If you had run the code on the actual sheet, you should have run it from the module as there is not button attached to it. On the attached post #14, there are only two modules. The code is in module 1. You have also recorded macro on module 2.