Automatically change cell references by more than 1 when dragging a formula

[panza123]

I want to create a number of columns with the difference of two other columns:

1. First column: B2-A2.
2. Second column: D2-C2.
3. Third column: F2-E2.
4. Fourth column: H2-G2.

...


How can I create the first column and just drag it across the other columns so that the values are calculated as above?

 

[diddi]

copy paste the column in every second column, or fill right and delete every second column contents. if it is massive then fill right and use a macro the clear the columns not wanted

 

[panza123]

Thanks. I know how to get it to work but, partly to use this as an opportunity to learn how to use certain functions, I wanted to use code which would not require deleting any columns (ie, I wanted code that I could drag across columns).

 

[diddi]

i dont think you can... macro would do it

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1
2	1	2	3	5	6	9	10	14	1	2	3	4
Main

Cell Formulas
Range	Formula
I2:L2	I2	=INDEX($A2:$H2,COLUMNS($I2:I2)*2)-INDEX($A2:$H2,COLUMNS($I2:I2)*2-1)