I'm not sure I understand, but maybe the techniques (code and manual) at Debra
Dalgleish's site will help:

http://contextures.com/xlDataEntry02.html
and a video
http://www.contextures.com/xlVideos01.html#FillBlanks



Gor_yee wrote:

Hi there...I need a VBA script that I can use to autofill down a
column...so if row a5 had a heading of "happy" and then z5 had a
heading of sad... I need that script to fill down from a5 to y5 with
Happy and then from z5 fill down to the next heading with Sad...

can you help??

--

Dave Peterson