ExcelBanter - Macro to change information and then delete it

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1