Sorting based on two columns using vba code

Question

Hi,

Here I have some CFN codes(C column) and Back order(EA) values. I need to sort values(K column) in descending order as well as the CFN codes should be arranged in sequence, because I have some CFN codes which are repetitive. Both the columns are to be autofiled based on Material (column D) I always appreciate if someone helped me with the code

Waiting for the answer.

Thank you

Answer 1

Dear Chandrasekaran. Gokul,

Greetings! Thank you for posting in Microsoft forum.

Based on your post, I found the following link, check if this helps you find the information:

Auto Sorting 2 columns in VBA - Microsoft Community

Further, we understand your requirement and we would love to help you with your query about macro/VBA code, however, our team focuses on general query, for example, installation and activation issue of Office 365 products. The situation you mentioned is related to macro/VBA code, you can to refer to this article: Office VBA support and feedback | Microsoft Docs to go to Stack Overflowby using the VBA/macro tag, along with any other relevant tags as there are also many experienced engineers and experts in the forums there who can help with the code.

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites, or any support related to technology.

At the same time, we will also keep this thread open, so other Community members and Experts can also share their suggestions and inputs.

Thank you for your cooperation and understanding!

With sincerest regards,

Neha Singh | Microsoft Community Moderator