Update Change Formula With Insertion of new Column

[williamx]

Hello

I'm looking to automatically update a change formula as new columns are introduced. Essentially looking to always target the previous two columns.

For Example

=(B1-A1)/A1 Is looking at the difference between A & B, each week a new column will be introduced to the Left of the formula and to the right of the previous data.

Is there a way to automatically update the formula from =(B1-A1)/A1 to =(C1-B1)/B1

Thanks

 

[Snakehips]

@williamx. Does this help?

Book1
	A	B	C
1	10	5	-0.5
2
Sheet1

Cell Formulas
Range	Formula
C1	C1	=(OFFSET(C1,0,-1)-OFFSET(C1,0,-2))/OFFSET(C1,0,-2)

 

[williamx]

@Snakehips Yes! exactly what I needed. thank you!