If you enter a formula and then fill it across the columns this should
work
if Coluimn A has a name then column B will have a number and column C
will have this formula
=B1+1

copy the formula across the columns and it should work for you


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=528872