Sort rows in groups/set of 3 rows.

**Elmholt** · 05-29-2013, 03:38 AM

Hi.

I hope someone in her is able to help me.

I need a marco that sort rows in set of 3 rows

So row 5 - 7 and the values in them belong together as 1 set, row 8 - 10 and the values in them belong together as 1 set and so on.
The values to sort by is in column A, and in the 1'st row of the row set.

So for the 1'st set (Row 5 - 7), then values to sort by is in cell A5, and for the 2'nd set (Row 8 - 10), the value to sort by is in cell A8....

I know that is properbly not easy to code, but i hope it is possible.

Thanks.

**TMS** · 05-29-2013, 04:49 AM

A macro would, I guess, need to "pre-process" the data. That is, add the key field, for example A5, to the block and add a sequence number, 1,2,3, to the rows. You could then sort sequence number within key field.

So, I think it's do-able. Just 3 stages: add the sequencing information, normal sort and delete sequencing information.

Regards, TMS

**Elmholt** · 05-29-2013, 04:52 AM

Hi TMShucks.

Do you happen to know how to do this?

BR
Søren

**TMS** · 05-29-2013, 05:19 AM

I could probably work it out. What would you have me do it with? Other than your description, I have no idea what your data looks like and, therefore, what might and might not work.

I suggest that you post a sample workbook.

Regards, TMS

**Elmholt** · 05-29-2013, 05:59 AM

Hi TMS.

I attached a sample of how my sheet and data looks like.

I hope that will do, and you are able to help me.

Thanks in advance.

Br.
Søren.

**Marcol** · 05-29-2013, 07:34 AM

This workbook does as I thought you needed, with a formula rather than VBa, based on post #1.
I'm not clear from your sample in post #5 as to what needs sorting.

The formula in B2 is a CSE array and must be confirmed with Ctrl+Shift+Enter, not just Enter, before dragging down.

Formula:

Please Login or Register  to view this content.

This sorts the groups of 3 from Z-A, change the operator >= to <= to reverse the sorting to A-Z.

**Elmholt** · 05-29-2013, 08:07 AM

Hi Marcol.

I am not sure how to use this, but let me try to explain what i use the Excel for.

I use the excel to keep track of what is going in and what is going out form each customer.
Each customer can have several item number. Each item number owns 3 rows (IN, OUT, SALDO) = 1 Row Set.
In the first row of a set, the Cust. no (Customer Number) Cust Name (Customer Name) is entered.

As each customer can add new items to the list, i will add a new row set ( = 3 Row), after the last used row set, and enter the data accordingly to the custmer and iteme number.
For the overview purpos, I then need to be able to sore the row set, so all row set for custmer "A" is listend under eachother, and the customer "B" and so on.

I hope it makes sence?

Br.
Søren