Excel, Accelerated: Spreadsheet update from other spreadsheet

Acceleration techniques include: Programming a macro with open & close workbook, disable screen updating, create a formula, create a variable, autofill, paste formulas