Hi,

Im trying to add a formula that adds +1 to a cell reference number.

example
a
1=c12 original
2=c12
3=c12
4=c12
5=a1+1 cell ref which would be c13
6=a2+1 cell ref which would be c13

I have tried drag and drop and it does not follow sequence

thanks


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=573466