Hello MD,

The UDF's you created are just what "The Doctor Ordered" and much appreciated.

I can't explain what I was thinking when I inserted column G.... hence no idea what to say. In short order though I will be using your functions and adding to them.

On the subject of UDF's how does one incorporate them into vba. In this instance I am referring to the possibility of having the UDF's automatically do their job when the "Quoted Cost" (E38) was entered or pasted in?

I do not wish to waste your time and am only exploring the possibility of further automating the order entry process.

Regards,

Carpiem