Hi guys,
I have a question in relation to R1C1 notation and fill series. I have a huge excel file that contains a huge amount of formulas, which the notation R1C1 is helping to reduce.
However, I have a list of formulas that are identical with the exception of the row number.
As an example, I have "=SUM(Data!R[255]C[3]:R[350]C[3])", then "=SUM(Data!R[8270]C[3]:R[8365]C[3]), then "=SUM(Data!R[16285]C[3]:R[16380]C[3])" and so forth. The difference between each of those formulas is the row number which is always 8015 more than the previous one. Now I could enter the formulas one by one, but that just not an option as it would take too me long. Any ideas on how I could speed up the process? I don't seem to have the option "fill series" as I suppose excel does not recognise that it is in fact a series (as only thing changing is the row number with 8015 more every single time). Maybe a macro (but I am not very good yet with macros)?
I would really appreciate some help with this.
Many Thanks!
I have a question in relation to R1C1 notation and fill series. I have a huge excel file that contains a huge amount of formulas, which the notation R1C1 is helping to reduce.
However, I have a list of formulas that are identical with the exception of the row number.
As an example, I have "=SUM(Data!R[255]C[3]:R[350]C[3])", then "=SUM(Data!R[8270]C[3]:R[8365]C[3]), then "=SUM(Data!R[16285]C[3]:R[16380]C[3])" and so forth. The difference between each of those formulas is the row number which is always 8015 more than the previous one. Now I could enter the formulas one by one, but that just not an option as it would take too me long. Any ideas on how I could speed up the process? I don't seem to have the option "fill series" as I suppose excel does not recognise that it is in fact a series (as only thing changing is the row number with 8015 more every single time). Maybe a macro (but I am not very good yet with macros)?
I would really appreciate some help with this.
Many Thanks!