In article , Claus Busch
writes
Hi Colin,

Am Tue, 10 Jun 2014 17:22:00 +0100 schrieb Colin Hayes:

http://www.chayes.demon.co.uk/sample.xls

please have a look:
https://onedrive.live.com/?cid=9378A...B6121822A3%213
26#cid=9378AAB6121822A3&id=9378AAB6121822A3%213 26
for "sampleCH"


Regards
Claus B.

Hi Claus

OK that's excellent - thanks.

There remains one small issue , though.

It seems that while the routine successfully ignores blanks in the Bcode
column , it is also making quantity 0 for these items.

These items do exist , it's just that they don't have a Bcode. For this
reason the Quantity column needs to left untouched for these items. I'm
not sure why the routine would make them 0.

Would you be able to look into this?

Many thanks.



Best Wishes