There are no hidden rows, I will clarify what I mean with an image.

What I want to do is use the fill handle to repeat this series down
colum B. So I want cells B5 and B6 to populate as =A3, then the next 2
cells down =A4.


Your example above goes up in odd numbers missing all the even numbers
in between, which is my problem. I need each 2 cells to be the next
consecutive number.


+-------------------------------------------------------------------+
|Filename: example.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4364 |
+-------------------------------------------------------------------+

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