Change top line data and remove lower lies

CJ13A02 Grp ..... Cherry Coke 500ml PET 24 Std 145
CJ13A02 927 7471 Cherry Coke 500ml PET 24 *Std 137
CJ13A02 927 87471 Cherry Coke 500ml PET 24 Blnk 8
CJ18A08 Grp ..... Diet Coke 500ml PET 24 Std 377
CJ18A08 927 8732 Diet Coke 500ml PET 24 *Std 365
CJ18A08 927 88732 Diet Coke 500ml PET 24 Blnk 12

the above is a print out of two product items. Instead of six rows I want
just 2. It is dislpayed as three per item because there are what we call
standard and then blanket codes, they are then added together to create a grp
(group product data).

I need the grp to be changed in this instance to 927and ..... to change to
the code that has *std in the column i.e. Cherry coke code 7471 has *std and
87471 has blnk, i need it to put 7471 in there. Then remove the two previuos
lines

Example of required output:

CJ13A02 927 7471 Cherry Coke 500ml PET 24 Std 145
CJ18A08 927 2083 Diet Coke 500ml PET 24 Std 377

Question:

What I need is a macro to create this output

Regards
Gaz

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-programming/200511/1
.