Can Excel be setup to automatically sum imported data

R

RobertJTJ

I am creating data rows via Visual Basic and writing them to an Excel
template file. The data is composed of multiple groups and the number of rows
is variable. Is there a way to set up the template to perform an auto sum on
specific columns within each group of data rows?
 
K

kassie

Seeing that you are using VB to do the work, you can also use VB to enter the
formula to sum the relevant number of cells. You have to tell VB where to
start. Get this into 2 variables, increment the 1 variable every time you
write a new row, and at the end of the process you will have the start row
and end row for your SUM formula
 
Top