When copying a row from one KPI import sheet to another where both sheets have pre-populated UoMs, the paste method used in Excel determines which UoM is re...