I have a fill right problem, where I want excel to give me the result of
the cell below.

In a Horizontal table, with years along the columns, I have the
following in B1
'Sheet 2'!A1 + 'Sheet 2'!A100 + 'Sheet 2'!A200

Is there a way to fill right, so I get the result in B2
'Sheet 2'!A2 + 'Sheet 2'!A101 + 'Sheet 2'!A201

instead of B1,B100 and B200

Any help appreciated.
Hywel
Manchester UK


--
Hywel
------------------------------------------------------------------------
Hywel's Profile: http://www.excelforum.com/member.php...o&userid=14824
View this thread: http://www.excelforum.com/showthread...hreadid=483426