Macro to copy formula on worksheet close
 

I need to create a macro that will copy a formulas when the workbook is closed. Is this possible and how do I get the formulas to copy down the entire column that has data. The formulas would be on worksheet 2 and would be copied to worksheet 1

Thanks1