Problem sorting

[ikkuh]

Hi,

I made a sort button with a macro to sort collum 1 and a button to sort collum 2.
Now in collum 1 are name and in collum 2 is the line (this is just a letter).
So these 2 collums acctually belong together.
I want to sort on name A->Z with 1 button but the "letter" in the other collum needs to stay with the samen name.
I also want to sort the "letters" A->Z and then tht names need to stay to the letters they belong to.

Is there a way to do this?


Thanks in advantage!

Grtz!

 

[RonB1111]

Use only 1 macro & button and when "recording" the macro, select both columns 1 and 2, then your primary sort is on col 1 and secondary sort is on col 2.

 

[ikkuh]

Hi,

I tryed that.
But I have some problems:
1)In the original file I merged some cell to make it look good (B-H) = collum 1 and (I-J) is collum 2 so it says that the cells don't have the same amount of cells.
2)I made them same size and tryed it the name still doesn't stay with de letter =/

Any id's what I do wrong in problem 2?
or maybe how I can fix problem 1?

thanks for your time!

Greetz ikkuh

 

[RonB1111]

Open the Macro window (Developer-Macro): Here are a couple things to check:
1. Make sure you have only 1 macro. If you have 2 or more, you may have the wrong macro assigned to the button.
2. Click "Edit" and look at the macro code. Make sure it is selecting only D:D (or to exclude your merged cell, maybe D2:D10000). If you're not sure, please post the macro here.