Hi again

I like the simplicity of your code, but i doesn't seem to work quite
the way I intended. The problem is that "myValue" has to be changed
between each searchloop(if that is the right word).

Actually I need the rows copied to be grouoped in twos.
Each pair can not add up to more than 8664 when added together. E.g.
these are my data:
A B C
11 8500 4200
12 8400 2700
7 7500 4000
3 7000 2700
8 6800 3500
13 6000 2800
9 5400 2440
14 5400 2900
1 5200 2700
2 3600 2700
4 3600 2700
6 3500 2700
10 2500 4100
5 2400 2700


The macro has to pair two rows but their combined value in Coloumn B
can never be more than 8664 and then remove both rows from the
original datasheet and then do the same on the rest. Ending up in all
the data being grouped in the sheet "Dataark".
I don't expect you to write the whole macro for me but any help wil be
greatly appreciated... I have an idea of how to do it, but i'm not
quite sure if it will work..

//Kasper