Sort specific rows and leave headers

**sp1ken** · 05-12-2009, 07:56 AM

Hi all,

I have some problems with sorting.

I have the following:

A1: Prio
A2: Header1
A3: 3
A4: 1
A5: 2
A6: Header2
A7: 3
A8: 1
A9: 2

etc..

And I would like to accomplish the following ( preferly by clicking somewhere in the A1: Prio cell )

A1: Prio
A2: Header1
A3: 1
A4: 2
A5: 3
A6: Header2
A7: 1
A8: 2
A9: 3

etc...

Thanxs!
- Petter

**modytrane** · 05-12-2009, 09:04 AM

look at the sample attached.
you can make the macro more flexible in terms of Headers and length of data cells. It all depends on a number of factors. does the headers change, does the length change etc.?
modytrane

**sp1ken** · 05-12-2009, 10:29 AM

Perfect!

Thank you very much Modytrane. Works just as i wanted!

Just to complicate it a little bit. If it´s possible, is there a way do define dynamic # of rows, eg "All rows between header1 and header2", if I for example wanted to add a row?

It´s not necessary, but really nice if it was possible!!!

Thanxs again!

- Petter