Macro instead of thousands of formulas

[rhudgins]

in my spread sheet on the Today tab in column S:AE I have a number of formulas that need to be dragged down about 5000 rows when my spreadsheet is finished. When I do this the spreadsheet becomes extremely slow to the point where it does not open. Is there a way to write a macro instead of having the formulas to speed up the spreadsheet? Any help would be great!