Hi,
I have a question dealing with summing a range. I am sorry if this has been covered so if there is an answer in another message just point me to it.
I have a rather large spreadsheet I am importing from another file and need to sum every set of 91 numbers in a column to a new spreadsheet. So, I am summing A1 - A91, A92 - A182, etc. down the column.
I need a to sum these into columns in a new spread sheet. The new spreadsheet will have the same number of columns, but will consist of the sums. I can't seem to write the link in a few cells and then fill down. I have experimented with a little VBA, but am not good enough to write code to do this. Can someone suggest a method for this.
I also need to do this for one column and be able to just fill across the sheet.
I appreciate your help.
Regards,
Jeremy
This message was edited by jlharrier on 2002-02-19 22:18
This message was edited by jlharrier on 2002-02-19 23:11
I have a question dealing with summing a range. I am sorry if this has been covered so if there is an answer in another message just point me to it.
I have a rather large spreadsheet I am importing from another file and need to sum every set of 91 numbers in a column to a new spreadsheet. So, I am summing A1 - A91, A92 - A182, etc. down the column.
I need a to sum these into columns in a new spread sheet. The new spreadsheet will have the same number of columns, but will consist of the sums. I can't seem to write the link in a few cells and then fill down. I have experimented with a little VBA, but am not good enough to write code to do this. Can someone suggest a method for this.
I also need to do this for one column and be able to just fill across the sheet.
I appreciate your help.
Regards,
Jeremy
This message was edited by jlharrier on 2002-02-19 22:18
This message was edited by jlharrier on 2002-02-19 23:11