G
Geoff
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
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