If you select cell B5 and look in the bottom left corner of the cell
there should be a little black box. Hover your mouse over it and your
cursor should change to a + left, click your mouse and drag down
however far you want to go. This should do it automatically for you


--
Steel Monkey
------------------------------------------------------------------------
Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051
View this thread: http://www.excelforum.com/showthread...hreadid=573616