C
Crowbar via OfficeKB.com
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
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