Copy and arrange cells in unique way
 

I am starting an excel file that extracts file from another worksheet,
then after it is extracted, A4 cell has a value in cell B4, I wanted
to copy all the cells in column A&B to column D&E in such a way that
when the word "check is encountered in column A, it will arrange
itself in the last with the other cells that contain same words before
the word "check". I wanted to do this in macro or formula if possible.
I have tried to look in the forums but I can't find a closer solution
to this. The problem on this is that Column A&B are changing and only
the word "check" is constant in some cells. Please help..Can anyone
please help me on these..
This a what I wanted to do:

A B D
E
EFFECT - ARRANGED
Description Weight Description Weight

GO1 0.5 GO1 0.5
GO2 0.4 GO2 0.4
MO1 0.7 GO1 CHECK 0.7
MO2 0.9 MO1 0.7
FO1 0.8 MO2 0.9
FO2 0.9 FO1 0.8
TO1 0.6 FO2 0.9
TO2 0.8 FO1 CHECK 0.7
GO1 CHECK 0.7 TO1 0.6
FO1 CHECK 0.7 TO2 0.8

Copy and arrange cells in unique way
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Geoff" wrote in message
...
I am starting an excel file that extracts file from another worksheet,
then after it is extracted, A4 cell has a value in cell B4, I wanted
to copy all the cells in column A&B to column D&E in such a way that
when the word "check is encountered in column A, it will arrange
itself in the last with the other cells that contain same words before
the word "check". I wanted to do this in macro or formula if possible.
I have tried to look in the forums but I can't find a closer solution
to this. The problem on this is that Column A&B are changing and only
the word "check" is constant in some cells. Please help..Can anyone
please help me on these..
This a what I wanted to do:

A B D
E
EFFECT - ARRANGED
Description Weight Description Weight

GO1 0.5 GO1 0.5
GO2 0.4 GO2 0.4
MO1 0.7 GO1 CHECK 0.7
MO2 0.9 MO1 0.7
FO1 0.8 MO2 0.9
FO2 0.9 FO1 0.8
TO1 0.6 FO2 0.9
TO2 0.8 FO1 CHECK 0.7
GO1 CHECK 0.7 TO1 0.6
FO1 CHECK 0.7 TO2 0.8