Forum Discussion
Increase Cell Reference by 1 each day
Hello, I would like to automatically increase this formula each day from this: =SLOPE(Data!C2:C14,Data!B2:B14) to this: =SLOPE(Data!C2:C15,Data!B2:B15) to this, etc: =SLOPE(Data!C...
Hi Timothy,
You have an option to create a table from your existing data so that any formula referred to a column of this table will expand automatically if you add a new record.
Please open the attached file and select cell C14, then press Tab to add a new record, and see how the formula will expand.
Hope that makes sense
Haytham
This works Perfect, Thanks!
