Use Macro to replace =sum() for large amount of data

[SheldonCooper]

Hi,


This is what I currently have
:

Google Drive:
https://docs.google.com/file/d/0B89c...it?usp=sharing


I currently have =sum() formula in the STARTING from the column range:
EA101 --> =SUM(CA101:CA105) <<sum of="" 5="" rows="">></sum>
Drag to autofill across, and to bottom, 4 rows above the data source (DA101:DW421). Otherwise, it will sum blank cells.

GA101 --> =SUM(CA101:CA106) <<sum of="" 6="" rows="">></sum>
Drag to autofill across, and to bottom, 5 rows above the data source (DA101:DW421). Otherwise, it will sum blank cells.

iA101 --> =SUM(CA101:CA110) <<sum of="" 10="" rows="">></sum>
Drag to autofill across, and to bottom, 9 rows above the data source (DA101:DW421). Otherwise, it will sum blank cells.

KA101 --> =SUM(CA101:CA115) <<sum of="" 15="" rows="">></sum>
Drag to autofill across, and to bottom, 14 rows above the data source (DA101:DW421). Otherwise, it will sum blank cells.

MA101 --> =SUM(CA101:CA120) <<sum of="" 20="" rows="">></sum>
Drag to autofill across, and to bottom, 19 rows above the data source (DA101:DW421). Otherwise, it will sum blank cells.



The Sample excel I have uploaded only consists of 321 rows (CA101:DW421).
However, the actual data (multiple sets of data) that I have consists of 300000+ rows.


As a result, the =sum() function that I have takes too long to caculate/out of memory everytime I provide new data from CA101:DW.


I am wondering if there is a faster way, maybe a macro, that could do the calculation instead of using the formlua?



Thanks,

Sheldon

 

[RoryA]

Cross-posted and answered here to save everyone time.