Text file to Excel conversion with Ascending order

Dear all Mates,

Kindly arrange the small modification in existing code.this code is developed many weeks back by well wisher from this site.

My Code as below:

Please Login or Register  to view this content.

with help of above code developing excel file, and required modification is mentioned in sample excel file.and text file also attached.please find the attachments

Kindly modify the Code

Thanking you,

Best regards.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Try this line of code

Please Login or Register  to view this content.

Originally Posted by YasserKhalil

Try this line of code

Please Login or Register  to view this content.

Dear sir,
Thank you very much your kind help, i got your new code as below

HTML Code: 

please make small correction for above code. i need without "A" column, i want only B to F Columns only. please modify your code.

Thanking you,
Best regards.

If you don't need column A you can clear the contents of it using this line

Please Login or Register  to view this content.

Just use the word "Delete" instead of "ClearContents"
Hope this helps you

pvsvprasad Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

Originally Posted by YasserKhalil

If you don't need column A you can clear the contents of it using this line

Please Login or Register  to view this content.

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

pvsvprasad, please take the time to review our rules. There aren't many, and they are all important. You have violated three rules in this thread.

Originally Posted by pvsvprasad

Dear sir,
I cannot understand your rule.
now what i do for fulfill your rule?

Modify all your posts so that you enclose your code in code tags. Post #2 gives instructions for how to do this.

Also you have posted the same question to Mr. Excel. You must add a link to that thread here. Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

This thread is also a duplicate. I am closing the other thread.

You need to use code tags when posting code. You have been around here long enough to have seen that these are required when posting code here. I will add them for you - this time, please use them from now on. See my footnote to see howe

Hi Prasad
You can post new thread with the new request if it different from the original request
Regards