Math Operation on Worksheet VBA Excel

On a Excel Workbook I have many Worksheets, my code until now creats a new sheet called “Base 2”, and then copy some data from another sheet to this new one. I would like then to perform a math operation between 2 columns on this “Base 2” worksheet and place the result on another column on the same sheet, but only as value. Ie: I want to divide column E with column J, and place the results on column K as value. Both columns have at least 35,000 rows.

 

Begore the precious part (After creating “Base 2”, before mixing the two columns), I would like to divide column E by 100 and column 1000 as value.

 

Any tip, where to look, is greatly appreciated. Thank you

Contributor Asked on April 1, 2017 in VBA: Macros.
Add Comment
1 Answer(s)

Any doubt, I am working on excel

Contributor Answered on April 1, 2017.
Add Comment
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.