Macro to enter value then sort specific range

[PinkMafia14]

Hi there

Got some great tips on writing a macro, but need further assistance. Creating a new thread because requirements have changed / become more complex and I don't want to confuse the matter.

1 - FIND LAST ROW WITH DATA AND POST BELOW
The first step in my macros seem to work... I need the macro to find the last row with data in column C and in the row below that type "Spares Commission" or "Commission" or "Consultant Fee" etc (see buttons with macros linked to them in file entitled "example-2).

2 - SORT SPECIFIED RANGE
I then need the data in range C32:M500 to be sorted first by column I, then C, then F.

CURRENT PROBLEM:
SORT LAYERS
The issue at the moment is that each time I click on a button and run a macro, it sorts by adding an extra level of sorting to the range, until too many levels exist and it bugs (see "print screen" which is a screenshot showing I clicked on Commission 3 times and Spares Commission once and there are 4 layers to the sorting).

MULTIPLE SORTING
The second problem is that it currently only sorts on column C, not as described above - not sure how to do multiple sortings.


Hope this is clear...

[Steffen Thomsen]

Hi,

Try looking at this post and see if it helps.

http://www.excelforum.com/excel-prog...hen-sorts.html

Steffen Thomsen

[royUK]

Why have you started a new Thread?