I know there's an easier way to do this so I'm looking for some help on how to write this code to make it easier and faster.
Range("AA6").Value = Range("S6").Value + Range("U6").Value + Range("W6").Value + Range("Y6").Value
Range("AG6").Value = Range("k6").Value * Range("AA6").Value / 1000
Range("AA7").Value = Range("S7").Value + Range("U7").Value + Range("W7").Value + Range("Y7").Value
Range("AG7").Value = Range("k7").Value * Range("AA7").Value / 1000
Range("AA8").Value = Range("S8").Value + Range("U8").Value + Range("W8").Value + Range("Y8").Value
Range("AG8").Value = Range("k8").Value * Range("AA8").Value / 1000
Range("AA9").Value = Range("S9").Value + Range("U9").Value + Range("W9").Value + Range("Y9").Value
Range("AG9").Value = Range("k9").Value * Range("AA9").Value / 1000
Range("AA10").Value = Range("S10").Value + Range("U10").Value + Range("W10").Value + Range("Y10").Value
Range("AG10").Value = Range("k10").Value * Range("AA10").Value / 1000
Range("AA11").Value = Range("S11").Value + Range("U12").Value + Range("W12").Value + Range("Y12").Value
Range("AG11").Value = Range("k11").Value * Range("AA12").Value / 1000
Range("AA13").Value = Range("S13").Value + Range("U13").Value + Range("W13").Value + Range("Y13").Value
Range("AG13").Value = Range("k13").Value * Range("AA13").Value / 1000
Range("AA14").Value = Range("S14").Value + Range("U14").Value + Range("W14").Value + Range("Y14").Value
Range("AG14").Value = Range("k14").Value * Range("AA14").Value / 1000
Bookmarks