Insert SUM value on varying row
Posted by Zif on September 13, 2000 6:47 AM
I have a macro which summarises data from variuos sources onto an "output" worksheet.
The output can have anywhere between 300 and 5000 rows of data each time I run the macro.
What I'd like to do is to automatically add to th ebottom of each column of data the value of the SUM of the cells above.
The row number on which this total figure will be appearing will of course vary depending on how many rows of data there are.