Dear all,

I am having a problem with this excel formulation. Hope someone can help me.



-------------column 1-----------------column 2------------------column 3
row 1____'sheet1'A3-'sheet1'A2___'sheet1'A4-'sheet1'A3___'sheet1'A5-'sheet1'A4
row 2____'sheet1'B3-'sheet1'B2___'sheet1'B4-'sheet1'B3___'sheet1'B5-'sheet1'B4
row 3____'sheet1'C3-'sheet1'C2___'sheet1'C4-'sheet1'C3___'sheet1'C5-'sheet1'C4

What i want is if i drag the cell from left to right, eg. row 3, it change from C5 to C6 and so on until C100.
When i drag the cell down, it will change from C3 to D3, and so on until Z3.


Currently if i drag it down, instead of changing from A3 to B3, it change from A3 to A4. I don't want this, i want A3 to B3.

Please help. Thanks a lot.