PDA

View Full Version : Is it possible to use vba to automate a count on recurring data?



wedd
02-05-2011, 05:15 PM
Hi, is it possible to automate a count to work out the amount of new data added to existing data by writing a macro to a button, and by clicking on the button the count will automatically count the figures and round up a total. Is it possible to do this, if so how can this be done? Would you have any example code how to this?


Thanks for your contributions:friends:

IBihy
02-08-2011, 08:44 AM
Hello,
basically, yes, that's possible. Depends on how complicated you want it. Assuming the button is on the sheet, and there are no gaps (i.e. empty rows) in the values you want to add up, and assuming that your values are in column C, check out the attached workbook.

Greetings,
Isabella