Convert values from one unit to another using VBA

[siddharthsopori]

Hello Gurus ,

PFA the sample file.
We need to convert the values highlighted in YELLOW to the Sales Unit of measurement from Base unit of measurement using VBA
IF sales UoM = Base UoM , do nothing to the values of the corresponding row
IF Sales UoM = GAL and Base UoM = L , values = values*0.264172 (all the values of the corresponding row)
IF Sales UoM = LBS and Base UoM = KG , values=value*2.20462(all the values of the corresponding row)
*The number of rows and columns are not fixed so definite values of rows and columns cannot be used Eg. From F2:S2 cannot be used.

Regards
Sid

 

[Nebu]

Hi:

Is this what you are looking for I have not used any macros.

Thanks

 

[siddharthsopori]

Hi:

Is this what you are looking for I have not used any macros.

Thanks

Hi ,
Thanks for your reply .
Issues in the solution you provided :
1) We need the conversion to be done for individual entries of the row , not the row total.
2)All the quantities are in Base UoM , so , if Sales UoM = Base UoM , then no conversion is needed .

Regards
Sid

 

[Nebu]

Hi:

I am afraid I understood you correctly, do you mean to say that, you want to replace the vales in column F to S based on the condition.

Thanks