Following is project description
Have a spreadsheet of 93K data elements. 1 column of 93K rows.
Need to add every 100 elements and multiply by 10, to create a result of 930 data points in another column.
In other words: Need Sum(1:99)*10, Sum(100:199)*10, and so on
Also need to graph(scatter plot) above data on y axis. x axis will correspond to row numbers.
For example data points for graph in (x,y) is (1, Sum(1:99)*10) (2, Sum(100:199)*10) and so on.
Need a macro/subroutine that can be used against another dataset.