How to set the ascending order datas in the desired result?

I have a file having 9000 rows with S.No. 1,2,3,4 etc. ,in ascending order.It has downloaded from available system in the company.

Can it be possible the file be in the format of desired sheet ( attach file ) through macro working or VBA Codes?

For more clarification,please refer the attach file of download sheet and Desired Sheet.

Please check the attached workbook. Format the table on the Download worksheet before running the code as the format will be copied.

Hi John,

Always eager to understand other solutions.

Could you explain what you are doing in this loop

Please Login or Register  to view this content.

and, would the below not be the same?

Please Login or Register  to view this content.

or am I completely missing the point?

Great.Many-2 thanks for the excellent solution provide.

Pradeep,

if you are happy with my contribuition you can click on the star ("Add Reputation") to show your appreciation

Excellent and minimise time solution.Glad to find it.

Can you provide me one more solution of VBA codes of my another question posted by me as on today i.e.10/10/2013?

Pradeep,

Have you clicked on the "Add Reputation" link (left side of my post underneath the avatar)?

I don't see it in my overview

Now check and confirm.

Thanks and Regards

Yes, received. Thank you