how do you convert units when you copy values from one sheet to another

[gapreet]

Hello people,

I am working on some programming where I have to transfer values from one sheet to another sheet. I am facing some issue.

* sheet which I am working is template I just need to transfer values from source sheet to target sheet which I am able to do but issue is I need to change units (SI unit etc etc ). when I transfer values I want to transfer converted values.
so can any body help me with any solution please thank you

[MrShorty]

You ask how I would do it, but I would not use VBA for this task. When I do something like this, I set up the spreadsheet to use Excel's built in CONVERT() function (https://support.office.com/en-us/art...d-666c810f9af2 ). At the top of my input column, I enter the "from unit" text and paste the data into this column. In the adjacent column, I have the "to unit" text at the top of this column, then I have the to unit column filled with the formula =CONVERT(A2,$A$1,B$1). When I have a new set of data to convert, it is as simple as entering/pasting the new data into the from unit column and changing the units text in the top row.

If I were required to use VBA for this task (maybe because I will receive a large bonus for using as few spreadsheet columns as possible), I would consider looping through each input value and performing the conversion before writing to the spreadsheet. I could also see using VBA to paste into a simple spreadsheet like I describe above, the paste/write the resulting values from the from unit column into the destination sheet. I could see writing a VBA procedure based on the .PasteSpecial method (https://docs.microsoft.com/en-us/off...e.pastespecial ) where I use the pastespecial method to multiply the pasted data by the correct conversion factor.

What kind of approach would you like to take? What questions do you have about implementing that approach?