• Ask a Question
150
Insert Image Size must be less than < 5MB.
    Ask a Question
    Cancel
    150
    More answer You can create 5 answer(s).
      Ask a Poll
      Cancel
      Contributor

      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

      Asked by fduquen on April 1, 2017 in VBA: Macros.
      1 Answers
      Contributor

      Any doubt, I am working on excel

      Answered by fduquen on April 1, 2017..