Two Date Columns in same spreadsheet: Date wise sorting problem

[fahadferoz]

Hi

I have two date columns in the attached spread sheet. All I want is to sort the spreadsheet by dates. I am trying to do it by using sorting tab but it is not showing the way I want it. In the spreadsheet there is is a gap between the chalan received and payment made. I want to put a row gap as the payment date normally happens after chalan received. But the row gap is not showing. Rather excel is showing the these two in the same row.

Would you please help me out.

 

[Hui]

Can you please explain more clearly "chalan received and payment made" which columns are these?

What do you mean you want a blank row?
Please post the file with a manually inserted blank row/s if that makes it more clear

 

[fahadferoz]

chalans received = means a consignment is received from company
payment made = means a payment has been made by us to the company for the consignment.

The columns I am talking about is 'B' and 'J'

Please have a look at what I want in the attached file.

 

[Hui]

Why not add a helper column


O1: Sort
O2: =INT(ROW()/2)
Copy O2: Down
Then copy paste Column O as values on top of itself

or alternatively
O2: =Row()
Copy O2: Down
Then copy paste Column O as values on top of itself

Now you can use that to sort ?

 

[fahadferoz]

Mr Hue
I got really confused. The spreadsheet contains a lot of data which manually can't be numbered (the one you showed). Is there any way for the excel to do it automatically.

Thanks for helping.

 

[Hui]

The problem is that to maintain the order and allow sorting there must be something to anchor the positions
The helper column doesn't have to be visible if that is an issue

The only other way is yo use a VBA script to reformat it via code

 

[fahadferoz]

Many thanks for your valuable suggestion. I am already using a VBA script. Attached please find the workbook 1. Here the tab import has a VBA script. Could you write the code and insert that in the current VBA.

Please help me on this.

 

[fahadferoz]

Dear Mr. Hui
Should I post this thread to VBA forum?

 

[Hui]

No its ok here
it has grown into a potential VBA solution

 

[fahadferoz]

OK
Hoping to get the solution.

Thanks Again.

 

[fahadferoz]

No its ok here
it has grown into a potential VBA solution

Dear Mr. Hui

Is there any way to do it?