Hi, here's a plain example of what I'm trying to do:
In cell B1 is the formula: =A1
In cell B2 is the formula: =A1
In cell B3 is the formula: =A2
In cell B4 is the formula: =A2
In cell B5 is the forumla: =A3
In cell B6 is the formula: =A3

(you can see where this is heading..)

The problem I have is that I want to use the fill handle to copy this
series down a whole column, however Excel just won't see the pattern
here! (or I'm missing something obvious)

Help please!


--
jhct
------------------------------------------------------------------------
jhct's Profile: http://www.excelforum.com/member.php...o&userid=31562
View this thread: http://www.excelforum.com/showthread...hreadid=512566