The new code is using the description ONLY as the criteria for totaling and
delting. Do you want me to change the code so if the sku values are
differrent no to do the delete? I don't thing this make sense.


One solution is what I have done for lots of other people. A lot of people
don't do the deletes, instead they add a rows between sections a put a total
line to total each section. In your case you probably want to combine the
lines where the SKU numbers match using the original code. The sort by
description and add total lines between items with the same description but
different SKU numbers.


"nikkynock" wrote:

Joel
your fast response is really appreciated - i've noticed that on some lines
where the parent value and sku value are different (generally VERY small
difference in value), the parent line is still removed. Am I doing it
correctly?
many thanks