Need help with creating a VisualBasic code for Excel to sum a column every 1 minute and output the summation to another column?
Need help with creating a VisualBasic code for Excel to sum a column every 1 minute and output the summation to another column?
Suggest you follow Don's tutorial Run a Macro at Set Intervals in Excel, set the interval to 1 minute and use that to trigger a macro to update your SUM cell(s) using the Calculate method e.g.
Worksheets(1).Columns(5).Calculate
changing the indices in bold (e.g. column 5 above is E)