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