Hi SamT ,
I thought you forgot about me!! THANKS super THANKS for your help as always
Here you are:
Sheet2 – Problem with request.
1. Blank Spaces (fixed by the 1st step procedure)
2. Different Formats (fixed by the 1st step procedure)
3. Wrong currencies, basically:
a. When column B = US20 then Freight must be expressed in USD in all the others cases in EUR. (it would be wonderful to have those errors already highlighted by the Step 1st in Sheet2)
b. Price should always be expressed in USD. (it would be wonderful to have those errors already highlighted by the Step 1st in Sheet2)
4. Wrong Import Duties, basically when NL10 in Column B import duties column must have a value, when Column B <> NL10 there must be NO import duties.
(exception when the part number (column C- Sheet2) starts with 8FI* even with column B = NL10 in column B there must be NO import duties.)
Problem with the mass upload tool (reasons why I need to check after the upload, just FYI)
1. We change price/freight very often, when too many “condition” have been uploaded for the same Part Number the upload can go wrong (new price/freight don’t overwrite the old ones)
2. When too many conditions have been uploaded for the same part number funny IFR may be created like NL10 with import duties or wrong vendors.
3. When we have too many vendors for the same part, the upload tool can mess up and change price/freight for the wrong vendor.
PLEASE NOTE :
Concerning point 3. a & b I’m exploring solution with the conditional formatting but I got stuck with the currency as Conditional formatting doesn’t seem to me able to handle that.