Sort rows based on two columns and leave blank row between them

[andriano]

Hello everyone,

I wanted to ask something , I am trying to create a macro that sorts rows based on value of 2 columns, but every time that a value changes in either of them to leave an empty row between them.
Is that possible? In simple words i want to separate my rows with the empty row while sorting them out alphabetically based on two columns.

Please check my screen shots. Test 1 is my spreadsheet before the macro. Test 2 is how i need it to be after the macro. The two columns that i want it sorted out is First GDS then Rate.

Thanks in Advance.

Kind regards, Andriano

[Naveed Raza]

It would be great if you provide sample workbook , its make easy to resolve query.

[kalak]

Please Login or Register  to view this content.

[andriano]

Thanks a lot Kalak for your answer! Let me ask one more thing i just added couple of columns is it possible to sort them out correctly because for some reason when it is sorting those column values are wrong?

Regards Andrianos

[kalak]

@Andrianos,

You should provide a sample file since your verbal description gives too little information about just what you want.

where on the worksheet did you add columns and in what way is the sorting of them and any others (if so which ones?) 'wrong'?

[andriano]

Yes sorry for that i dont know how to put the workbook in forum so he are some images like before . We have test 3 and want it to become test 4 .

I tried the code you posted but the column nights and total revenue their values are wrong when it sorts them based again on GDS and Rate.

Thanks

Regards Andrianos
test 3.jpg
test4.jpg

[kalak]

@Andrianos

You can try the modified code below to see how it works for you.

Regarding attaching files, this makes a good response much more likely, since it's then easy to test any codes and in fact to ascertain more accurately just what the problem is.

To attach files, look at the 'Additional Options' under the 'Your message' box when you are making a reply. 'Manage Attachments' is in the second item. It's really quite easy to do.

Please Login or Register  to view this content.