How to Sort Two Dates in same page using VBA

[fahadferoz]

HI

Please have a look at the attached file. Here in 'Import' tab I want to sort the B column using Oldest to Newest Date and in the same page I also want to sort the K Column using Oldest to Newest.

Here I want to mention that column A to I is related to the Chalan we receive from the company.

And J to M is related to the payment we make to the company.

Any help would be hugely appreciated.

Thanks in advance.

 

[Marc L]

Hi !

As an Excel sort can do the job (except if your will is illogic !),
so join your desired result worksheet according to your initial attachment.
​

 

[fahadferoz]

I am a bit new to VBA. Can you please be a more specific.

 

[Marc L]

Just join an attachment with your desired result
in order to make us understand your need
as Excel has already a sort feature …

A reminder : just read VBA help of Range.Sort method …
All is in VBA inner help for beginners !

Another reminder : any beginner can activate Macro recorder,
operate manually within Excel worksheet : a free base code is generated !
​