Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Sum Column Every 1 Minute

0

Need help with creating a VisualBasic code for Excel to sum a column every 1 minute and output the summation to another column?

Answer
Discuss

Answers

0

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) 
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login